Question : When I say efficient, I mean total storage(kb), and not excessively burdening the CPU. I have 70 columns […]
Tag: storage
Automatic change of “initial size” of a database?
Question : I just had a problem : days ago, on one of my client’s databases, the LDF file suddenly […]
Data from different tables into one table
Question : I’ve requirement where I need to store information from different sources in my system and the process that […]
SQL Server storage – evaluate the number and types of read write operations for the existing deployment
Question : Training for SQL Server, one of the questions in Learning material says: Before migrating on-premise SQL Server deployment […]
Backup Compression SQL Server vs PURE
Question : We are having a SQL 2016 Standard Edition Server holding 4TB of data. And the compressed backup using […]
How can I estimate the size of a new table?
Question : We have tables with a lot of data (50M new rows each month, just in one table). Now […]
SQL Server data files and RAID
Question : I have a server with a RAID1 volume (OS + apps) and a RAID10 volume (database). The RAID10 […]
TempDB Best Practices For Shared Storage [closed]
Question : Closed. This question needs to be more focused. It is not currently accepting answers. Want to improve this […]
Disk file effects of delete and vacuum
Question : I have a very frequently updated table with 240 million rows (and growing). Every three hours 1.5 million […]
Attempts to reclaim unused space causes the used space to increase significantly in SQL Server
Question : I have a table in a production database that has a size of 525 GB, of which 383 […]