Viewing 15 posts - 3,151 through 3,165 (of 22,227 total)
You can do a lot of development locally and then deploy to the cloud.
However, cross database queries are horrifyingly slow and difficult to maintain within Azure SQL Database....
"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 26, 2018 at 5:16 am
It says right at the top that the process with an id equal to this value process694076108 was chosen as a victim. You can then find the input buffers 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
June 26, 2018 at 5:11 am
100% agreement with Anthony. Why write your own script for this? Ola Hallengren's scripts or the Minion Backup scripts will do the work for you. Why reinvent the wheel when...
"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 26, 2018 at 5:04 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 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
Viewing 15 posts - 3,151 through 3,165 (of 22,227 total)