Tom,

Currently there are 148 incorrect and 147 correct answers. This leads me to believe that your interpretation of the question may be correct. 😉

Enjoy!

SQLRNNR (6/10/2014)

---

I'd probably go with setting. But the question is...

UPDATE:

MS has announced there will be a final service pack for 2008 and 2008 R2 later this year.

Final Service Packs

I left a comment at the bottom of the page asking...

I don't think the mistake in the corrected answers is that Local should be Global because we are looking for limitations as the correct answers. Probably the word not...

Based on the MS wording in this KB article (KB2958696), it doesn't look like there will be an SP4 for 2008.

This article describes cumulative update package 17 (Build number:...

... Do me a favor; put your database object code in source control. Add all your DDL for tables, views, functions, stored procedures, and anything else you use....

... fuel for their idiocy of I WANT IT NOW AND IT SHOULD COST NOTHING AND IT BETTER INCLUDE EVERY FEATURE - SOME I HAVEN'T EVEN THOUGHT OF YET....

... what I’m challenging you to do is to avoid reducing conversations to “pick two” when sometimes the right person with the right idea might well be able to...

This is a manually intensive process the good guys have to keep up on...

venoym (4/10/2014)

---

Guess I'll be the first to say that the "twist" was not appropriate. The question was titled and about the TRY...CATCH structure in SQL Server, the string length...

I think I found the error in the code. The password and instance sid columns had the same values.

SELECT

'principal name' = CAST(0x57652063616E6E6F74 AS...

+10

Any business oriented group that limits their membership to a certain ethnic, sex, religion or other group is by...

To illustrate the points being made about parenthesis.

DECLARE @Logic TABLE ( ID INT, Product VARCHAR(50) );

INSERT INTO @Logic

VALUES ( 1, 'Baseball Hat' ),

...

Funny, the first thing I thought when I read the title of the editorial "The DBA is Dead" was "Long Live the DBA!" 🙂

It looks like the author had...

I got it right but only by guessing if the question was to be answered or the description.

The problem is that, as written, the question and the description have 2...