Building a SQL Restore Script When Your Backup Runs
It is handy to have a SQL Restore script ready to go for every backup that you run. Here is a script that will help with that.
Tag: ORDER
Instant File Initialization (IFI)
One way to improve performance on SQL Server is with IFI or Instant File Initialization. Normally files are zeroed out on a database growth during an AUTOGROW, RESTORE, CREATE DATABASE or ALTER DATABASE. This is done by SQL Server when the file grows, it runs through that file and writes zeroes to the entire new allocation in the file. The …
DBCC SqlPerf
Being day 27 of the DBCC Command month at SteveStedman.com, today’s featured DBCC Command is DBCC SQLPERF. Description: DBCC SQLPERF is used to do a couple different things. Show a list of all the wait stats on your SQL Server. Show a list of the transaction log and the space used in the transaction log. Clear the wait stats. Clear …