Browse by Tags

• VLDB Maintenance

• How to avoid using shrink in SQL Server 2005?

  Late night blog post to round out spring-break vacation... A number of customers I’ve spoken to in the last few weeks have been making use of database or file shrink in situations where they don’t really need to. There are few recurring scenarios I’ve Read More... Posted Sunday, April 15, 2007 11:45 PM by Paul Randal - MSFT | 4 Comments Filed under: Shrink, VLDB Maintenance

• How does your schema affect your shrink run-time?

  For part two of my short series on data file shrinking, I want to look at how elements of your schemas can cause shrink to take much longer to run. In SQL Server 2005, three things in your schema will drastically affect the run-time of data file shrink. Read More... Posted Thursday, March 29, 2007 10:58 AM by Paul Randal - MSFT | 1 Comments Filed under: Shrink

• Turn AUTO_SHRINK off!!

  This week's topic is data file shrinking. I've seen lots of mis-information in the last few weeks and I've had a bunch of questions about it. First up is auto-shrink. In my opinion, this feature causes way more problems than it solves (in fact, I can't Read More... Posted Wednesday, March 28, 2007 5:13 AM by Paul Randal - MSFT | 5 Comments Filed under: Shrink