TechNet Magazine: July 2010 SQL Q&A column

The July edition of TechNet Magazine is available on the web now and has the latest installment of my regular SQL Q&A column (and I forgot to blog about it a couple of weeks back).

This month's topics are:

  • Why shrink runs slower on some databases than others
  • Is it true that autogrow should always be turned off?
  • LOB storage considerations 
  • How long consistency checks will take 

Check it out at http://technet.microsoft.com/en-us/magazine/ff808322.aspx.

4 thoughts on “TechNet Magazine: July 2010 SQL Q&A column

  1. Why should we store the LOB data at another filegroup?
    Except speeding up at restore (partial restore),
    What are its benefits?

  2. OK, But I mean: Does it have a performance effect?
    I think when the LOB data and other data to be stored at the one filegroup,
    The probability of fragmentation increases.
    Because statistics IO shows increased read-ahead reads.

Leave a Reply

Your email address will not be published. Required fields are marked *

Other articles

Imagine feeling confident enough to handle whatever your database throws at you.

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.