A town/city thrives because people are in it, using its amenities.

I find I spend more in the local shops being at home.  I'll go to the butcher more often and...

I certainly prefer the hybrid setup.  It was never so much the being in the office I didn't like, more the commute.  It felt like two hours a day of...

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 1 year, 4 months 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...