-
StatPress TopPosts
Category Archives: File Management
Want to Make Your SQL Server Run Faster for Free?
Want to Make Your SQL Server Run Faster for Free? The trick is to properly manage your VLFs. What are VLFs? The short anser is that VLF stands for virtual log file. SQL Server database log files are made up of many smaller virtual log files that make it easier for SQL Server to manage the log files. Continue reading
Why Would a Delete Make My Database Grow?
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
Script to Create A TempDB File Per Processor
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
A Busy/Accidental DBA’s Guide to Managing VLFs
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
How to Shrink TempDB in SQL 2005
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 DBCC FREEPROCCACHE, DBCC SHRINKFILE, Shrink, SSC, TempDB
7 Comments