This is a topic that’s been well covered, but in the interest of spreading good database practices, here’s a very quick note on instant file initialization (IFI) and database files. (As always, you should read the fine print – meaning Microsoft’s documentation – before you do anything on a production system.) Instant File Initialization IFI […]
Category: sqlserverpedia-syndication
Puzzling TVFunctions
I had the opportunity to tune a highly-used function the other day, and was most puzzled by the difference between the old and the new function. This was on SQL Server 2005, and I was able to repro the issue on-server, but not on my SQL Server 2012 instance. The old function specified the return […]
MidnightDBA tutorials and webshow now on iTunes!
We’ve been slacking for way too long, but as of this week our video RSS feed is up to date! Now you can subscribe to conveniently get ALL of our videos – tutorials and the DBAS@Midnight webshow (warning: the webshow is explicit for language). We do have this feed hooked up to iTunes, but right now […]