Viewing 15 posts - 1 through 15 (of 57 total)
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...
July 8, 2020 at 11:03 am
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 syntax2. Yes...
January 31, 2018 at 12:16 pm
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....
March 30, 2013 at 8:11 am
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...
December 14, 2011 at 8:16 am
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...
December 14, 2011 at 8:01 am
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
December 14, 2011 at 7:34 am
Thx, being at a client with strict firewall rules (no youtube), could you possibly summarize, or point to a text/html link 🙂 Thanks!
December 14, 2011 at 7:23 am
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...
May 5, 2011 at 7:18 am
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 -
April 28, 2011 at 10:47 am
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...
April 28, 2011 at 7:43 am
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...
April 4, 2011 at 8:11 am
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...
December 10, 2009 at 11:35 am
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...
November 19, 2009 at 9:35 am
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...
April 1, 2008 at 8:47 am
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...
April 18, 2007 at 8:58 am