Additionally, remember that unique indexes drive choices by the optimizer but may never end up in sys.dm_db_index_usage_stats, so be extra cautious about using that as a reference for which indexes...

For the love of Codd, store numbers in a number defined column and strings in string defined columns. Anything else is begging for trouble.

In this case, CAST is your...

Yeah, it's the "why" really, for the most part.

Look, code any way you want to. It's not my place to dictate or declare anyone wrong, or evil or anything like...

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