seen from Vietnam
seen from United States
seen from China
seen from Colombia
seen from United States
seen from Philippines
seen from United States
seen from United States
seen from Philippines
seen from China
seen from United States
seen from United States
seen from China
seen from United States
seen from United States
seen from United States
seen from United Kingdom
seen from South Korea
seen from United States
seen from Argentina
Boosting SQL Server Performance with Instant File Initialization
In the fast-paced world of database administration, efficiency and speed are paramount. One often overlooked feature that can significantly enhance SQL Server performance is Instant File Initialization (IFI). This powerful capability reduces the time it takes to initialize data files, accelerating database operations such as restoring backups or adding data files to a database. Below, we explore…
View On WordPress
File Growths
New Post: File Growths #entrylevel #sqlpass
I hinted at file growths in my previous posts about shrinking data and log files. Then I talked about growing log files in my post Database Log VLFs. However, there are still some unanswered questions about growing data files. Should I use autogrowth? What should I set it to grow by? Why do manual growths, and how do I know how much to grow by or when a growth is needed? Can I and should I use…
View On WordPress
