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...

I agree with Talib, four days doesn't tell you much.

However, where did this index come from? Execution plans don't create them on their own as you stated....