Viewing 15 posts - 31 through 45 (of 67 total)
Victor Kirkpatrick (3/31/2014)
March 31, 2014 at 5:58 am
I went through the trouble of adding login king_login, and not as a member of sysadmin role. The table was created in the wonderland database with schema dbo, not king_schema....
March 31, 2014 at 5:55 am
This question should be deleted before people go away with a very very very bad assumption: I can throw a clustered index on a column and always expect it to...
December 2, 2013 at 5:55 am
Might be an easy one, but I learned something: the WITH VALUES clause. Thanks.
October 18, 2013 at 6:07 am
Great QOTD today! Reminded that failed inserts still increase the identity. And, if you did NOT include the SET IDENTITY OFF statement, then people would have been complaining that you...
April 24, 2013 at 5:36 am
peter.row (3/20/2013)
Basic question designed to seem like a trick?This applies equally to SQL Server 2005 and 2008 not just 2008R2 and 2012.
Exactly... delete cascade is available in 2005 & regular...
March 20, 2013 at 5:21 am
Best QOD in quite some time. Question & explanation clear and concise, got the question right, AND I learned two things to boot. Thanks demonfox!
March 5, 2013 at 7:33 am
One of the best QOTD's I've seen in a long time, with a great explanation and code setup. Thanks.
February 13, 2013 at 6:15 am
Love answering a question correctly and getting it wrong. Either correct the question and say total IO and not "reads", or correct the answer.
September 21, 2012 at 5:07 am
Awesome question. Instinct was to pull the trigger on clustered, but then I made sure to read all the answers. So I tried to create the table and also add...
June 14, 2012 at 7:02 am
As Grant says, I think "B" is your best option. We've been doing this for years using Tortoise Hg. I don't have ANY IDEA how we used to manage the...
April 5, 2012 at 5:47 am
CDC is available in the Enterprise, Developer, & Evaluation editions of both 2008 and 2008 R2
February 2, 2012 at 12:39 pm
Good question about a very useful feature that a lot of people do not appear to know about. You can also use the OUTPUT clause with the MERGE command too....
February 2, 2012 at 6:22 am
We have upgraded all of our systems to 2008 R2. Whenever a new release comes out, we are all over it, upgrading our SQL Server systems at the first opportunity...
October 21, 2011 at 5:48 am
Had to bone up on TDE to get this one... which btw, is exactly what Steve is looking for in the QOD anyway, right? Good question. Learned a few things...
May 31, 2011 at 6:46 am
Viewing 15 posts - 31 through 45 (of 67 total)