Viewing 15 posts - 3,151 through 3,165 (of 22,219 total)
"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
June 20, 2018 at 1:31 am
If you're getting deadlocks from the process, I'd double check the query tuning first of all, the indexing next, and the calls made by the queries. If it's the same...
"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
June 19, 2018 at 6:40 am
They're both defined locally. The Recovery Time Objective is how long it takes to recover your database. You have to test it. Recover just a database. Recover a database plus...
"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
June 19, 2018 at 4:45 am
I am absolutely not seeing similar behavior. Uninstall and reinstall maybe?
"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
June 19, 2018 at 4:41 am
I'm with Jeff, first thought, it depends.
However, I'll go a little farther. With low levels of data modification, even if the computed columns are doing a lot of work,...
"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
June 19, 2018 at 2:33 am
Partitioned views and traditional partitioning are not supported because Azure SQL Database implements the PaaS offering differently. However, lots of people do logical partitioning with Azure SQL Database letting 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
June 19, 2018 at 2:31 am
Only concern I have is that looks like a big transaction. Will there be multiple copies of this running at the same time? If so, you could see a lot...
"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
June 19, 2018 at 2:29 am
Lots of information there. I'll try to make some suggestions.
First, instead of copying all the data every time there's a promotion from one state to another, I'd rather...
"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
June 19, 2018 at 2:26 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
June 11, 2018 at 5:50 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
June 7, 2018 at 5:20 am
Without seeing the query and the execution plan, I can do more than offer vague platitudes.
So, here's one. A primary key is a unique index. How can replacing...
"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
June 7, 2018 at 5:18 am
Why all the group by statements when you're not doing any aggregation that I can see? That's going to blow performance out of the water. Especially grouping on, what, 14...
"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
June 7, 2018 at 5:13 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
June 5, 2018 at 5:45 am
There are tiny differences in the estimates, but the plan hash and the query hash are identical. To all intents & purposes, they're the same plans. I saw some implicit...
"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
June 4, 2018 at 12:49 pm
"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
June 4, 2018 at 7:44 am
Viewing 15 posts - 3,151 through 3,165 (of 22,219 total)