Viewing 15 posts - 1,876 through 1,890 (of 22,219 total)
I have had to pass the parameter in to an internal variable that matches it exactly, and just assigns the value over. That made a HUGE difference when I...
"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, 2020 at 10:36 am
the only way I can see you doing that is setting up a profiler trace that saves to a table.
Ha! Gotta post this. I saw you recommend Profiler and...
"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, 2020 at 10:32 am
Cursors in cursors? Serious anti-pattern here. I'd strongly recommend reassessing the approach.
"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, 2020 at 10:26 am
Sorry, had to step away for a presentation. I agree with the suggestions so far.
"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 12, 2020 at 4:15 pm
Close off the connections or restrict access to the database would be the best guess I have. Probably you just need to plan on tearing down & rebuilding the AG...
"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 12, 2020 at 11:32 am
Can you show the code where the function is used? That will allow people to understand the context in which they have to work. Otherwise, the answer is, pull 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
March 12, 2020 at 11:31 am
Last I read the EU has reached out to the Airports about this. The reason they're flying the planes is because of the "use it or lose it" attitude...
"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 11, 2020 at 11:04 am
It's the insert and update that are locking the table.
You can ignore these locks by using the nolock hint:
select count(*)
from mytable with (nolock)
BUT!!!
Know...
"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, 2020 at 2:02 pm
Execution plans, run times, I/O, data, data, data. You can't simply say IN good, NOT IN bad without data. You also can't say NOT IN good, IN bad without data....
"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, 2020 at 11:18 am
I'm with Jeff. Pick and choose which of these indexes you drop & recreate. There are many, many tests out there that show inserting into a clustered table can be...
"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, 2020 at 11:15 am
I'd suggest next time you run a blocking report to understand why it's blocking. SELECT COUNT(*) has to do a scan, either of the table or an index. It's counting...
"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, 2020 at 11:05 am
Running out of support software is a serious business risk. I'd focus on that above anything else. I know this stuff comes with a price tag, but talk to 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
March 9, 2020 at 1:31 pm
Take a look at the execution plans when it's compiling in each compatibility mode to understand how the behavior is changing.
"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 9, 2020 at 11:49 am
You're trying to do an in-place upgrade? This is the installation software that is generating these errors? I'm unclear precisely what's happening.
Also, whatever you do, avoid updating to 2014. It'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 9, 2020 at 11:47 am
Without seeing the code, it's hard to know for sure if this is the best way to get things done. It is possible within T-SQL to reference a data set...
"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 9, 2020 at 11:42 am
Viewing 15 posts - 1,876 through 1,890 (of 22,219 total)