Nice question! I didn't have access to a server to test the code, so had to guess based on documentation. I saw nothing about the default algorithm, so I went...

I really like the question for illustrating this behavior of columns referenced in a subquery.

Like Toreador pointed out, though, after reading query 1, it was clear it would run successfully,...

@tom: Absolutely, but from the OP's post, it seemed he was wanting a way to exclude another set in addition to the set returned by the CTE, in...

Well, if the databases are in the full recovery model, you could take tail log backups, and then it'll be tough for the users to update any data 🙂

My preferred...

It can be done, but it's a bit of a pain to get working sometimes.

Check out this link[/url] for an example of how to go about this.

Cheers!

Just to point out an alternative, instead of using multiple EXCEPTs, each with a SELECT pulling a set you'd like to exclude, you could also just UNION the SELECTs in...

What parameters are you passing to the scripts?

At only 1.2% reported fragmentation, the index shouldn't even be getting touched with default settings.

Also, just to clarify, is all the time being...

The write stall has more to do with how your storage is performing than with the number of tempdb files.

Adding tempdb files is typically something done to relieve latch contention...

What do you want the value of Abstract_Area to be when EA.DataSet='discharges'?

I think there's probably some confusion around what the query's supposed to be doing in that case.

Cheers!

Well, this number is a bit skewed relative the general population, I'm sure, but the clients I work with are 90+% virtualized. In my case, we're a managed service/private cloud...

The discrepancy comes from where you're getting those numbers.

The big difference is that virtual file stats has information on physical reads and writes. The index usage stats DMV doesn't care...

Indeed there is.

Something like the following should do the trick.

I made some of the columns character data for no particular reason other than to throw a couple data types in...

Yeah, having some of that in Standard will be nice. I still won't be completely satisfied with respect to an eventual removal of mirroring, since I rather liked being able...

I'm not sure if I read that part of the post correctly, but I think the DNS aliasing part was with respect to making DR (log shipped, it sounded like?)...

@Lynn: Agreed, I would love to dive into that option. Unfortunately the OP specified that they can't touch the third party app's SPs. Perhaps pushing back on that...