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

I'd suggest taking a look at sqlcmd instead of bcp. There's a ton more functionality there. While you can run sqlcmd, or bcp, from xp_cmdshell, it's not considered...

Think of it this way, you're looking for the second space ' '. That's how you solve this.

If you use the command line with SqlPackage.exe - one of the options available is a log file.  Instead of importing using SSMS - use the command line with...

I know of no way to do that beyond simple testing. Sorry.

I don't think that runing the import process of a dacpac is logged individually anywhere. The statements that create the database, tables, etc., are certainly logged (and maybe just getting...