It's all Steve Jones. His idea. His execution. He deserves all the credit.

Yep. You're stuck. Either all the values are the same, then no update should occur and no change tracking needed, or, the data is inserted only, and no way to...

No arguments. Your interpretation may be right. But then, what are we trying to see here? Query performance but not queries? How then do you correlate the performance, "An unidentified...

It is possible for Extended Events to miss an event. The tool is designed so that it puts minimal load on a system. Part of that includes the ability to...

Yes!

Have you tested without the nonclustered index? If it's not used, why have it at all? And yeah, lots of inplace updates are very hard on a columnstore index. Everything...

Thank you Grant Fritchey!

1. how can we check the cache for DMVs and  how to set the cache for DMVs( or how to set the cache for different DMVs)...

Best of luck. If you have some spare time, please build me a tool that easily, simply, and quickly, subsets data for test systems with minimal customization or programming. Thanks!

Hi,

Thanks for the suggestion. I created the extended event successfully but while accessing it , it is throwing me the error: "The storage failed to initialize using the provided...

Please, please, please, no politics. I just wanted to encourage people to learn a little history, either their own or others. That's all.

If it was an oopsie, just say it was an oopsie. You don't have to go into lots of detail on a thing like this. That is, unless they want...

Yeah, I'm a little surprised by this one too. I love my country....

Tell them.

Don't beat around the bush. Don't try to cover up. Just say it. "I messed up. I took the server down. Here's what I did by accident. I'm going...

The only sure fire way to get this done with a high degree of accuracy would be to use Extended Events. You could capture batch executions and filter for the...

Ads always ask for more than the job. I don't know that I've seen one that was accurate since I stopped tending bar.

If you think you have to...