First of all kudos to Brian for his videos. I absolutely love them and have learned so much. Secondly I agree with the others regarding the dangers of...

Wow, no offense to any other authors, but this is probably one of the most valuable articles I have ever seen on SQL Server Central. What a great compilation...

Good introductory article. Have to somewhat disagree with you on the temp tables though. Breaking huge complex query into more manageable smaller queries, which utilize temp tables may...

Thank you, this is excellent tip. Where were you 6 months ago when I spent days working around this limitation??!!! :w00t:

Biran,

Thank you for sharing these videos with us. I have been really enjoying them. Sometimes it's hard to find the time to read a long article, but with...

Thank you very much for posting this great solution. Exactly what I was looking for! Another alternative is posted here: http://blogs.msdn.com/michen/archive/2007/08/02/redirecting-output-of-execute-process-task.aspx

I liked this simple technique and can certainly be helpful in cases when the database being restored is relatively small (I live in a data warehousing world, so 16GB is...

Thank you for the article. This is a long overdue great new feature. One instance I can immediately think of where it would be useful is when users...

Very nice article. I am sure I will be using the techniques introduced here in the near future. Some minor complaints: the screenshots at the end (dealing...

That's why I keep coming back to this site. To read articles like this one, written for us mere mortals. Thank you Jeff!

What a great tip. Thank you! It infuriates me that Microsoft wouldn't document better something as useful as this.

Thank you to all for your comments!

Yes, the AUTO_CLOSE is turned off. While do still have this issue, I think the problem is with the network connections between our...

Thank you for your reply. We are talking maybe a few MB of data (1000 records or medium size). Pulling over the network means that my coworker has...

Thank you very much for all the suggestions.  Windows 2003 turned out to be the culprit in my case.  The procedure for configuring Win 2003 outlined in the discussion referenced above by...

The asnwer listed as correct is fundametally wrong because it implies that this command reports ONLY information about the "Buffer Cache".  In fact there are other parts of the SQL...