Two of the options look identical.  I'm not sure there's a right answer to this at the moment.

Are these sessions actually causing problems?  Stopping them could do more harm than good and may not be the quick fix you hope it will be.  It's likely that any...

SSMS is, as its name suggests, simply a management tool for SQL Server.  The actual SQL Server engine and services run independently of SSMS and continue running whether there...

This proc allows you to delete by database which, according to the question as written, is managing the amount of data.  While it doesn't do the same exact job,...

You should start a thread about that 😉

Duplicate post

• This reply was modified 8 months, 1 week ago by  Neil Burton. Reason: Duplicate

I have the radio on when I'm working at home playing a classic rock station.  As much as anything, it's because I don't like sitting in silence and...

I have the radio on when I'm working at home playing a classic rock station.  As much as anything, it's because I don't like sitting in silence and it's a...

We started "using" it last year.  The customer insisted that we enabled it when we migrated and upgraded. ...

There doesn't appear to be an ALTER INDEX statement in the question.  As it is, although I think I know what the answer should be, I don't think it's answerable.

Philosophically speaking, how can "I don't know" be a wrong answer?

I looked right through the correct answer in the documentation (not enough coffee yet) so I clicked the answer that...

Good question but there's a typo that will catch people out.

Have you looked at the query execution plan?  There might be some clues as to what is causing the problem in there.  What kind of data volumes are you dealing...

You've just gotta love people that give a super low rating to an article or QoTD without leaving a reason.  🙁  I thought this was a great question because...

I agree with Frederico.  This

Databases with a compatibility level of 90, including backups taken on SQL Server 2005 (9.x), are automatically upgraded to a compatibility level of 100 when restored...