Viewing 15 posts - 346 through 360 (of 458 total)
Like others, I figured that Date was a reserved keyword, but then I thought "no", b/c the question said it would run on SQL 2005 and 2008. 2005 doesn't...
March 18, 2011 at 8:02 am
Sorry, inference on my part: your moniker, GSquared, was used in a Larry Niven short story.
Rich
February 28, 2011 at 8:48 am
Thanks GSquared for confirming this is an issue. (BTW, you must be a Larry Niven fan?)
I bit the bullet and downloaded VS Pro. We're an academic institution with...
February 28, 2011 at 8:43 am
.... and to add to the suggestion to use COALESCE, you can in fact use the NULL values to look for rows in Table 1 for which there is no...
February 20, 2011 at 10:17 am
Nice idea, but I don't like putting potentially long-running code calling things like email into triggers on system tables. What if email hangs for some reason?
I have a slightly...
February 17, 2011 at 6:52 am
Before I clicked the link (and therefore had not yet seen the answer choices), I was expecting Redgate to be an option. 😀
Rich
February 14, 2011 at 6:28 am
paul.knibbs (2/10/2011)
February 10, 2011 at 8:11 am
Another thing to consider about transferring large SQL backups over the network is.... compression. SQL 2005 doesn't support compressed backups, 2008 does.
I'm running 2005 and was amazed at the...
February 7, 2011 at 8:01 am
Great question, thanks.
Minor clarification: the 2 hyperlinks listed at the bottom of the explanation didn't contain a notification about future deprecation of the SP (not that I could find, anyway).
That...
February 7, 2011 at 6:45 am
I picked the correct answer, but possibly for the wrong reason. Maybe someone could comment?
Consider an unused database with no active transactions. If I either manually issue a...
February 4, 2011 at 8:41 am
Peter Trast (2/3/2011)
Warthog-faced-buffoon
Truly you have a dizzying intellect......
😀
February 3, 2011 at 3:17 pm
Peter Trast (1/27/2011)
(yes, I know what it means 😉 )
(never get tired of that one, how many times has it hit this thread? Never??? I cannot be the first......
February 3, 2011 at 1:34 pm
I've seen this error before, and I think it results from failing to alias all columns you return with T-SQL. The query you posted didn't alias the results. ...
February 3, 2011 at 1:19 pm
Your inner CASE statements require their own END statements!
Rich
February 3, 2011 at 10:17 am
Just to make sure there is no misinterpretation: there will be no such thing like performance improvement due to virtualization itself.
I should have been clearer. I didn't quite catch...
December 23, 2010 at 9:49 am
Viewing 15 posts - 346 through 360 (of 458 total)