Question : What would be the optimal allocation size for a backup disk for SQL Server? We have a 2014 […]
Tag: storage
Creating the database on different file groups
Question : What is the pros and cons of creating the database for a operational system on different file groups? […]
What is a Scalable Storage Mechanism for large TTL data collections
Question : We currently have a legacy webservice that stores each xml request/response in Sql Server. The data only needs […]
What is an efficient storage method to store Graph Data from GraphX (Spark)?
Question : I generate graph data using Spark’s GraphX library and I need an efficient way to store graph data. […]
MySQL 8.0 table with JSON column that uses JSON “merge” operations has 500k rows but analyze table shows 7MM
Question : I have a database table that according to TABLE STATUS has 7MM rows, but when I SELECT COUNT(*) […]
ERP (Oracle) real time backup [closed]
Question : Closed. This question is opinion-based. It is not currently accepting answers. Want to improve this question? Update the […]
EAV in postgresql
Question : I’m building an application that needs to be deployed several times, with a relatively well organized data model. […]
How does MySQL store data, can I detach a mysql Database?
Question : I have used SQL Server in the past which each database is kept in separate files (a data […]
Splitting TempDB into multiples files equal to number of CPUs
Question : The article SQL Server tempdb Best Practices Increase Performance suggests that I should split tempdb into a number […]
Best practices for SQL Server block size while formatting disks for data and log files
Question : What is the current best practice or general guidance on formatting the filesystem for SQL server database files. […]