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

Backups are basically all or nothing (although, if you structure your system and have lots of read only data, you can use partial backups and a partial restore). Backups...

I don't know of anyone that breaks apart queries into their component parts for troubleshooting. I'd look to two things to help with this. Instead of capturing batches using Extended...

The DMVs are completely dependent on the cache. That's where the information comes from. So, anything that affects the cache, will affect the data in the DMVs. For example, DBCC...

Not seeing your structure, it's hard to know what the issue might be. I'd break it down. Take the query down to it's component parts & rebuild them, one step...