Brad pulled back as well. This whole MVP grind can be a serious grind....

WINNING!

Yeah, if we screw it up, we try to make it right.

Grant,

This has been on my mind for a while. I *am* a bottleneck. Things would get done faster if I loosened up the reins. When I realised a couple...

Nuts! I wasn't paying attention.

What about wait statistics? Have you compared before and after there to see if it gives you a clue as to what's up?

As to Extended Events. They're not terribly difficult...

To add to what Grant has stated, I agree that "new" voices are a bonus on any forum but I have seen some "new" people come in with some...

My apologies.  I wanted to Quote Jeff's answer, but accidentally hit the REPORT link instead.  Are Admins/Mods able to please undo my error

This was the post (copied from my...

I would like to defend myself, just a little. I didn't say surrender completely. I said, surrender, just a little. A lot of our peers see our rants about idiot...

Along with what Grant has stated and since they said it did "regular" SQL Backups, have them do a test restore using native tools only to prove it's a...

Just a thought,

every post I've replied to in the last few weeks has had updates and new info from pretty much the same bunch of people on here.

Grant, Jeff,KTFlash,...

Also, thinking on this, are you saying that the query and the view are the same, but the view is slower? Or are you saying that you wrote...

Also, thinking on this, are you saying that the query and the view are the same, but the view is slower? Or are you saying that you wrote a query...

Yep, execution plan.

Also, grouping by a function means poor, or no, index use. Calculated column with an index could help.

Still, execution plan.

Just a caution. Partitioning is great for data management. Partitioning is horrible for performance. It only enhances performance when you see a near perfect ability of your code to always...