A SQL Server DBA myth a day: (14/30) clearing the log zeroes out log records
(Look in the Misconceptions blog category for the rest of the month’s posts and check out the 60-page PDF with all the myths and misconceptions
(Look in the Misconceptions blog category for the rest of the month’s posts and check out the 60-page PDF with all the myths and misconceptions
(Look in the Misconceptions blog category for the rest of the month’s posts and check out the 60-page PDF with all the myths and misconceptions
In last week's survey I asked how you manage the size of your database *data* files – see here for the survey. Here are the
Whenever I teach a class I’m amazed at the number of DBAs who don’t know about instant file initialization. Without wanting to redo blog posts
This is a quickie in response to a blog comment from my previous post on instant initialization: How to tell if you have instant initialization
As you may already know, instant file initialization is a way to prevent data (not log) file create and grow operations having to zero-initialize the
With training and consulting from SQLskills, you’ll be able to solve big problems, elevate your team’s capacity, and take control of your data career.