Thanks you Jeff for your accurate post; I will keep your observations in mind and I will consider them in they more general meaning. At the moment I am...

>> I have a table with 2 fields [sic] DocumentID and ArrivedDate. <<

You might want to actually read the standards for SQL. A field is a subset of a...

To add to that,

I agree with Ken here that the application side is better suited for this.

Personally, I would refrain...

To be honest, that sounds like a slow and possibly error prone process being made to be slower and more...

If my table has 1 Clustered Index (PK), and a dozen of non-clustered row-store indexes.

I drop constraint... (existing PK/Clustered Index), Create Clustered Columnstore index on the table.

After this should...

I'll second Grant's recommendation on Gail's articles.  Personally, I consider them to be THE "Goto" articles on the subject especially since she's keen not only about performance but also on...

I generally have no need for case sensitive data.  However, if I did, I'd likely NOT make the whole server...

First, and to be sure, I always appreciate anyone that steps up to the plate with an article, especially on such a topic.

I agree with Aaron.  This is NOT a...

I'll also add....

1. Might need an update on statistics.
2. Different or missing indexes.
3. Skewed data.

If you're running what you posted, it's not actually running.  Like I said in my previous...

It's amazing to me how the visceral fear from the /90s and early 2Ks about xp_CmdShell still continues.  Disabling xp_CmdShell does nothing for security except provide a 3ms speedbump in...

My question would be.... why do you NEED to go through the intermediate server to begin with?

You could create a synonym that points to a database, run your code, drop the synonym, recreate it pointing to another database, run the code, wash-rinse-repeat.  It's dynamic without having...

You're absolutely correct about "net use" assigning according to the current...