Viewing 15 posts - 2,851 through 2,865 (of 22,219 total)
If you're upgrading from anything prior to 2014 to 2016 or greater (and don't ever upgrade to 2014), follow this simple set of steps:
Restore database
Leave compatibility level...
"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
November 30, 2018 at 10:34 am
I'd experiment with making it a JOIN instead of an exists, but there's nothing inherently evil in the code that I can see. Did they give you a "correct" answer?
"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
November 29, 2018 at 6:21 am
There's no easy way to get that done, at all. Instead, you could reseed the identity to start at the max negative value and then let it increment naturally from...
"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
November 29, 2018 at 6:19 am
"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
November 28, 2018 at 4:28 am
Statistics out of date affect memory because the allocations will be wrong, causing all sorts of issues. If the stats suggest 1 row when 1 million will be returned, the...
"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
November 28, 2018 at 4:25 am
"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
November 28, 2018 at 4:21 am
I know some of the authors of the Microsoft books. They're good. However, they do "teach to the test". This means it will help you pass the tests. However, 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
November 27, 2018 at 6:10 am
Why not just use SQL Dependency Tracker?
"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
November 27, 2018 at 6:06 am
It does make the code harder to read though. While it doesn't matter from a technical or performance stand point with INNER JOINs as was already pointed out, it does...
"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
November 27, 2018 at 6:04 am
Like Chris, show us the execution plan to get good advice.
One immediate issue, "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood" Author of:
- Theodore Roosevelt
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 27, 2018 at 6:02 am
I don't know how it's extracting an MDF/LDF from the .BAK file (if it is). I assume it's possible because my company does some similar magic through one of our...
"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
November 27, 2018 at 5:16 am
Tiny nit. Take away the calculation. Make it before in a local variable. It might lead to different row calculations. You are getting a VERY large disparity in estimated versus...
"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
November 27, 2018 at 5:12 am
"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
November 26, 2018 at 8:48 am
25 columns is likely to be most or all of the columns (guessing of...
"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
November 26, 2018 at 8:11 am
Sounds like you're trying to recreate the functionality from the Query Store. I'd suggest you take a look at this open source project. It may help.
"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
November 26, 2018 at 6:53 am
Viewing 15 posts - 2,851 through 2,865 (of 22,219 total)