Viewing 15 posts - 526 through 540 (of 22,232 total)
Whatever will make the behavior the same. I can't tell from where I sit.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 20, 2023 at 3:43 pm
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 20, 2023 at 2:53 pm
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 20, 2023 at 2:45 pm
Security. Your login has different privs than whatever process you're running under through the server.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 20, 2023 at 2:40 pm
Thanks! Glad to hear it.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 20, 2023 at 1:05 pm
There's some great stuff. Thanks for sharing.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 16, 2023 at 5:50 am
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 14, 2023 at 3:44 pm
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 14, 2023 at 12:15 pm
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,...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 14, 2023 at 12:11 pm
It's basically the fact that the query is running longer, it has additional duration. It's explained in the documentation right here.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 13, 2023 at 2:12 pm
Thanks for the feedback everyone. Great stuff. And there should be a title now. I spotted that on Saturday and added it.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 13, 2023 at 12:50 pm
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 10, 2023 at 5:44 pm
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 10, 2023 at 5:39 pm
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 10, 2023 at 4:25 pm
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 10, 2023 at 2:42 pm
Viewing 15 posts - 526 through 540 (of 22,232 total)