Ken,  I know it’s been a while, but we used to chat all the time - so when I heard you the news, I wanted to wish you a speedy...

Thanks Sree and Sue.
1. I didn't yet try T-SQL ( and couldn't generate the script without adding the db), so I'd have to look up the syntax
2. Yes...

It is a little confusing what you're asking for, but based on your topic title ("adding dynamic sql") and looks like you are trying to build a dynamic where clause....

I was of course joking, and it is quite funny how Grant immediately replied after the "goof" comment. I am sure there is great value to the videos, just...

Thanks, Grant! This makes sense, and no I don't consider you a goof from the internet, as the previous poster suggested 😉

<<Maybe that index will save you tons of...

Wow - 3hours of video? Come on, I asked an opinion on a specific question. Why are you suggesting I sit to watch 3hours of video? Thx

Thx, being at a client with strict firewall rules (no youtube), could you possibly summarize, or point to a text/html link 🙂 Thanks!

Of course you are right 10.5xx is R2 (and SP1 for SQL 2K8 would obviously fail 🙂 - but that wasn't the point. Needs update. As per the...

judy -good question. You can derive this information, but will have to use Powershell. Aaron Nelson, aka, SQLVariant posted a blog to do just this -

Thank you, econwatch - I, as well as the sql audience, appreciate sharing your experiences and solutions with upgrading.

This was one issue that dogged me during an installation, and wanted...

First, let me disclose, my company offers these Remote DBA services. BUT, although I'd like anyone to consider using us, I won't specifically talk about them (except for my...

Thank you, all for your comments, and reading....hope that it is helpful. I think that it's great that many of you experts chime in and add your experiences and...

Hi, Max: Thanks for pointing that out, b/c as a matter of fact, I included with the submission for both SQL 2005 and SQL 2008. I thought you...

Just wanted to thank everyone for the positive feedback on the interview. I'm glad you enjoyed it and found it informative.

I'd love to do more similar interviews, if the experts...

Hi, All:

Thank you for your comments and reading my article.  It was meant to provide some interim solution to the maintenance issue. 

The xp_delete_file is I believe used in the maintenance...