Viewing 15 posts - 2,971 through 2,985 (of 22,219 total)
Everything xsevensinzx says...
However, if you get stuck to where you can't do both, the newer versions of SQL Server offer a bit of an out. With the ability...
"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
September 14, 2018 at 5:50 am
Changes made to data in tables or changes made to the tables themselves? If the latter, get your database into source control and deploy changes from there. That will 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
September 14, 2018 at 5:45 am
I'd suggest using source control on all the database to track changes. That way, any change made to the extended properties goes through source control, you have versions. That's going...
"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
September 14, 2018 at 5:41 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
September 14, 2018 at 5:39 am
I'm biased because they're my employer, but I heartily recommend Redgate SQL Monitor. One thing that you might really appreciate about it is that we have lots 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
September 14, 2018 at 5:31 am
Thanks for this. Think blocking is the most probable, and have set up an...
"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
September 14, 2018 at 5:22 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
September 13, 2018 at 8:37 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
September 13, 2018 at 8:33 am
My first thought would be blocking by another resource, so I'd focus there. However, it's possible that a recompile event leads to differences in the execution plan. Capture it 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
September 13, 2018 at 8:17 am
As long as you're capturing rpc_completed or sql_batch_completed, you're capturing the incoming calls. However, triggers could fire and affect things and you won't see them as such. Instead, you have...
"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
September 13, 2018 at 8:14 am
Couldn't you just UNION the two together?
"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
September 13, 2018 at 6:12 am
I'd suggest focusing primarily in the area of DevOps. Automation as administration or administration through automation if you like. I think this is the area that is most challenging, most...
"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
September 13, 2018 at 6:10 am
Sounds like the backup is corrupt. It happens. It's part of why validating backups is so important.
"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
September 13, 2018 at 6:08 am
ESAT ERKEC - Wednesday, September 12, 2018 6:17 AMHi Grant;
Could you share your bug report link?Thanks
I used the feedback link. There isn't...
"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
September 12, 2018 at 6:26 am
We want to use 1 instance per customer, so for 20 databases...
"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
September 12, 2018 at 6:02 am
Viewing 15 posts - 2,971 through 2,985 (of 22,219 total)