Viewing 15 posts - 3,151 through 3,165 (of 22,224 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 25, 2018 at 1:03 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 25, 2018 at 12:26 pm
Kurt Wimberger - Wednesday, June 20, 2018 7:18 AMThanks Grant. Very much appreciate the time you all devote to helping others.Kurt
Thanks... although...
"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 7:52 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 20, 2018 at 7:50 am
Besides me and Hugo, who will be at SQLGrillen on Friday?
Oh, and tune into SQL in the City at around 2:20PM. I'm going to finish the execution plans...
"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 6:20 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 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
Viewing 15 posts - 3,151 through 3,165 (of 22,224 total)