Why?

Union does that, to do it without union is going to be tricky, probably will need temporary tables or conditional joins (and those will be slow)

Yeah, parameter sniffing is parameters or variables. Bad plans is still possible, though less likely.

I suspect you're going to have to look at the plans, see if they're different...

Not a concern here, since XML columns, like the MAX...

I'd also suggest, while you're cleaning out the NOLOCK hints, replace the old-style joins in the WHERE clause with the JOIN clauses.

Plans can be aged out of cache, how long that takes is dependant on memory pressure, among other things. Plans also can be removed due to data changes on tables...

Unless you have some custom monitoring in place, you don't. SQL doesn't track that information.

Eirikur Eiriksson (11/3/2016)

---

GilaMonster (11/3/2016)

---

Neither page nor row compression will compress LOB columns (like XML), so it's not as easy as just ALTER INDEX (and the sp_estimate_data_compression_savings is only going to...

Neither page nor row compression will compress LOB columns (like XML), so it's not as easy as just ALTER INDEX (and the sp_estimate_data_compression_savings is only going to estimate savings from...

I assume you mean Query Store (as query hints forcing an index cause the query to fail if the index isn't there)

There's a couple of columns in sys.query_store_plan that let...

Why do you want to loop through the rows?

Single UPDATE statement with a WHERE...

And which of those is it not doing or doing incorrectly?

There's no sample data, so I can't test your procedure out.

btw, that's a very poor design for the table, it's...

Firstly, why are you using a cursor? It's very rare to need one in SQL, and they're slower than set-based code in the vast majority of cases.

Try set-based code first,...

What does your procedure not do that you need it to do?

You'll find that in sys.master_files.

VMs in Azure work well, not the hosted SQL DB (can't set up availability groups on those)

How to practice: Set it up with a sample DB (AdventureWorks or WideWorldImporters) and...