So, when we talk about comparing performance between something like a UAT system and a production system, we've got to get more specific.

Are you saying, for a given query, against...

For the first execution of a query, you only store a plan stub (basically a hash for the query, plan & settings affecting the plan) instead of a plan.  That's...

Security. Your login has different privs than whatever process you're running under through the server.

Thanks! Glad to hear it.

There's some great stuff. Thanks for sharing.

We get a bunch of tasks/requests to run t-sql scripts to update views or stored procs or bad data.

Does anyone know of a server product that can automate...

If you have the database registered as a data tier application, there's a way to do a test run to generate a script that would be run. You could then...

Sounds a lot like you might be interested in building out a DevOps pipeline. You'll want to pick a flow control tool like AWS Developer Tools, Azure DevOps, Jenkins, Octopus,...

It's basically the fact that the query is running longer, it has additional duration. It's explained in the documentation right here.

Thanks for the feedback everyone. Great stuff. And there should be a title now. I spotted that on Saturday and added it.

I had a personally rolled one for statistics I used to use. Then I used, oh gosh, what's her name, used to work for GoDaddy... well anyway, she stopped maintaining...

I find that the reason why most people poo-poo xp_CmdShell is because they don't actually know how to use it correctly and safely and they also forget that only...

Well, I moved half way across the continent on top of everything else, so, no, things are not what I would call normal, but they're pretty darned close. The one...

Thanks....the 2 tables in question are pretty small and have same amount of rows in both UAT & PROD

I've updated the STATISTICS on both tables and waiting for...

When it comes to index maintenance, I defer to Jeff.

The only I want to add here is that, as he stated, columnstore is a different ball of wax. Here's...