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:
Check it out at http://technet.microsoft.com/en-us/magazine/ff808322.aspx.
Back in 2009 I started posting a summary at the end of the year of what I read during the year and people have been
(Yes, this is for last year!) Back in 2009 I started posting a summary at the end of the year of what I read during
It’s the time of year again where companies do crazy sales on the day after Thanksgiving in the US, and we’re doing the same! All
Happy Fourth of July to all who celebrate! I’m looking forward to a great view Thursday evening looking west along the Skagit Valley with some
(The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can sometimes be more
(The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can sometimes be more
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.
4 thoughts on “TechNet Magazine: July 2010 SQL Q&A column”
Why should we store the LOB data at another filegroup?
Except speeding up at restore (partial restore),
What are its benefits?
You could also put that filegroup on slower, less expensive storage, if the LOB data isn’t used very often.
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.
Might do – depending on what you’re doing – you’ll need to test to find out in your situation.