Today must be my lucky day. Saw the question, decided it was too long & complicated, guessed at random, got it right. Now off to buy a lotto ticket 🙂

danielfountain (4/13/2012)

---

Hugo Kornelis (4/13/2012)

---

danielfountain (4/13/2012)

---

I am confused.

How come this is supposed to bring back 6 rows?

select top 5 with ties * from SSCSales order by cMonthSales desc

There are 4 records...

Tom.Thomson (9/12/2011)

---

It's eminently possible for different collations to ruin your day even if you avoid case-sensitivity like the plague. One of the most helpful things I've found for learning...

I think those of us who have had the "pleasure" of working with case sensitive collations had a distinct advantage in answering this question.

But a great question for those not...

I just wanted to add my 2 cents to this thread for others.

Whilst adding the account as sysadmin will get it to work, it is not a very good solution....

I had to look up what re-entrant meant...

Regarding VM licensing, we've just been through it with our Microsoft rep. They have a licensing model that provides a benefit for virtual servers. See page 3 of this PDF:

http://download.microsoft.com/download/2/7/0/270B6380-8B38-4268-8AD0-F480A139AB19/SQL2008R2_LicensingQuickReference-updated.pdf

It...

I found this article the other day which I found helpful on a number of levels - it may be quite useful to you here.

http://www.sommarskog.se/query-plan-mysteries.html

I've never use DTA, so I can't help there, however I find the missing index query at the below blog quite helpful. Exercise caution - don't blindly create an index...

Regarding SQL logins, I think the point here is to use them as a last resort when no other options are available.

In a web server/db server example, you could only...

I got the question wrong... but I still think I'm right, based on the way the question was stated.

If you have 8 disks:

- Configure as 1+0, you can have failure...

LUCAB (9/14/2010)

---

I was wrong answer: "Outer transaction is still open....rolling back... ".

I learned that my wrong answer can be obtained with a SAVEPOINT:

CREATE TABLE MyTable (MyId INT IDENTITY (1,1),

...

And they use to say immitation was the greatest form of flattery... Turns out plagiarism is the new immitation.

Congrats Thomas Kejser & Denny Lee on a great article!

The explaination was very interesting (which I learned from) but I felt the question didn't really illistrate the point very well, i.e. the net result was drop an index and...

If I were you I would analyze that procedure in more detail. Work out if there is a particular component / section / statement / anything that is taking a...