OK guys. I think it's way past time. We need to just unveil the magic "Run Really Fast" button that we know about and are hiding from the rest of...

I'm not sure about others, but I think this may be a tough nut to crack. 

First of all, I wouldn't put any kind of process inside your existing...

My big moment for PowerShell was when we were moving the data center. We had to physically disconnect all our drives and move all the hardware into a new location....

Yes. You need to look at redesigning.

Now, the bigger question is, what? That's going to be hard to say. Going off the index names (totally making an assumption,...

That one is going...

Gail asked for the table design. How many columns, their data types, the primary key, the clustered index, any additional nonclustered indexes, constraints, triggers, foreign keys. That's the information we...

The basics are very straight forward. Scroll down to the section on Extended Events in this article I wrote. It gives you the two basic metrics, some additional...