Category Archives: File Management

Why Would a Delete Make My Database Grow?

Posted on June 1, 2010 by David Levy

A while back I had a developer come to me complaining that every time they ran a large delete statement on a certain database the delete would fail with a message claiming the database was full. My first instinct was that they were doing something wrong so I asked for the script so I could try it myself. To my surprise, running the delete actually did fill the database. Continue reading →

Posted in File Management | Tagged , , | Leave a comment

Script to Create A TempDB File Per Processor

Posted on April 9, 2010 by David Levy

To satisfy my need to be lazy and protect me from myself I have written a script to add a TempDB file per processor. Continue reading →

Posted in File Management, Utilities | Tagged | 6 Comments

A Busy/Accidental DBA’s Guide to Managing VLFs

Posted on December 21, 2009 by David Levy

Introduction Properly managing VLFs can make or break the performance of your databases. There is a ton of information out there on the proper management of VLFs, but nothing I have found that tries to boil it down to the … Continue reading →

Posted in File Management | Tagged , , | 32 Comments

How to Shrink TempDB in SQL 2005

Posted on December 17, 2009 by David Levy

Introduction From time to time you find yourself needing to shrink some space out of TempDB. Shrinking database files is never my first choice but sometimes it is the best I have. Many people think that you cannot shrink TempDB … Continue reading →

Posted in File Management | Tagged , , , , | 7 Comments