storage Archives

What is the most efficient way to store a bunch of empty fields, and ones with only a few choices?

By adminPosted on February 3, 2023

Question : When I say efficient, I mean total storage(kb), and not excessively burdening the CPU. I have 70 columns […]

By adminPosted on February 2, 2023

Question : I just had a problem : days ago, on one of my client’s databases, the LDF file suddenly […]

By adminPosted on January 28, 2023

Question : I’ve requirement where I need to store information from different sources in my system and the process that […]

By adminPosted on January 23, 2023

Question : Training for SQL Server, one of the questions in Learning material says: Before migrating on-premise SQL Server deployment […]

By adminPosted on January 20, 2023

Question : We are having a SQL 2016 Standard Edition Server holding 4TB of data. And the compressed backup using […]

By adminPosted on December 29, 2022

Question : We have tables with a lot of data (50M new rows each month, just in one table). Now […]

By adminPosted on November 25, 2022

Question : I have a server with a RAID1 volume (OS + apps) and a RAID10 volume (database). The RAID10 […]

By adminPosted on November 19, 2022

Question : Closed. This question needs to be more focused. It is not currently accepting answers. Want to improve this […]

By adminPosted on November 13, 2022

Question : I have a very frequently updated table with 240 million rows (and growing). Every three hours 1.5 million […]

By adminPosted on November 2, 2022

Question : I have a table in a production database that has a size of 525 GB, of which 383 […]