Hey all, a bit rushed this AM. Thanks for all the feedback. Appreciate.

And yeah, fully teaching the why's & how-fors & 'causes around stuff like SELECT * or ;WITH or...

100%. Absolutely. The semi colon is a statement terminator. Meaning, the previous statement has to have...

So, you're jamming that semi-colon, which is a statement TERMINATOR, at the front of your WITH clause. Are you doing that on the second query? That could be the issue....

And, you're hopping a pretty big gap, the cardinality estimation engine change that occurred in 2014. You need to plan for that just as you worry about the exact versions...

You can't create a view from a stored procedure.

Why do you need to create a view from a proc? A view is something that should be created and left on...

If a query was in a wait state, as soon as the blocking process clears, it will start to execute again, no manual intervention required. If the query in question...

Page Life Expectancy is a crappy measure of performance. A common pattern is that sawtooth look that it gets. It grows & grows, then there's a data load, so the...

If I understand what you're asking for, I think the OUTPUT clause is what you're looking for. That will allow you to know exactly which records were deleted from...

If Member_MRN_lkupAllMBRNOs is a multi-statement table-valued user-defined function, that alone is going to cause pretty massive performance heads. Either switch it to being an in-line function, or eliminate the use...

I agree with Johan, you want to take a look at Data Masker. It's probably the single most sophisticated tool for getting this done, and it will absolutely keep relations...

That is an odd one. Are you under memory stress? Have you tried writing out to file? I generally don't recommend using the buffers because it does add considerable overhead...

Up front, I work for Redgate.

We, every monitoring tool, use the exact same set of tools you can use. Dynamic Management Views, Extended Events, Query Store, DMI queries, PerfMon, all...

Remember, that's a VM, so you're reading what it thinks it sees from within that VM. You should also run queries against the hypervisor to see how much CPU is...

Wait.

A terrabyte restore could take several hours depending on your disk, the amount of recovery needed, contention on resources with running processes...

Wait.

Or, look to the wait statistics to see what...

Pretty sure this query will do everything you're asking for and more.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning