You don't.  You have to drop both indexes and create...

Back, barely functional after a few airplanes, but I see your complaints and have forwarded them on.

I don't know what I can say or do and I'm fairly frustrated...

Heh... GETDATE(). 😀

Back, barely functional after a few airplanes, but I see your complaints and have forwarded them on.

I don't know what I can say or do and I'm fairly frustrated...

And, just to assure you this type of thing does work exactly as I've stated (and I'm sure that Eric would agree), I have a 2005 database that...

I think that the people who made the decision to move to to the cloud should have the sole responsibility of monitoring the costs to prevent all the...

I've got something I'm not aware of performing backups of my dbs at random times in the day. I think it is performing backups however it says 0 pages...

I think that maybe the HammerDB code you ran in the other thread is a better tell.

Dear Steve Jones...

I forget how long it's been since this site was moved to WordPress but it's been a long time.  Those of us long-timers that are left...

I've never attempted any certifications and I've never missed out on a job because of it.  I don't see the value, but as a learning tool it is probably...

Nice question, Alessandro.  Proof, yet again, that SQL <> SQL and that the basic training out there isn't working 😉

Dear Steve Jones...

I forget how long it's been since this site was moved to WordPress but it's been a long time.  Those of us long-timers that are left (not many...

Shop size doesn't matter to me.  What matters is the attitudes of management on both the Dev and Database sides of the house and the attitudes of the folks on...

Hi All,

I have couple questions related to Ola Hallengren's maintenance script. If anyone has the answers, please do reply.

1. In which order the rebuild and update stats...

I think that the people who made the decision to move to to the cloud should have the sole responsibility of monitoring the costs to prevent all the "I told...