Viewing 15 posts - 4,126 through 4,140 (of 22,227 total)
I don't understand, the Subscriptions table is in the JOIN of the query.
"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
January 13, 2017 at 11:11 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
January 13, 2017 at 11:09 am
It's hard to say for certain without seeing the execution plans. It could be contention on resources that's there in prod, but not QA. In addition to capturing and comparing 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
January 13, 2017 at 11:02 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
January 13, 2017 at 8:04 am
Just modify the capture script to include a filter for the database. You can modify it in that fashion.
"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
January 13, 2017 at 7:45 am
Be sure that you have measurements of the I/O and execution time of the query from before adding that index. You don't want to tune just on whether or not...
"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
January 13, 2017 at 7:43 am
However, this conversion isn't preventing the use of statistics or the index. Fix it? Sure. But it's not causing you performance headaches.
"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
January 12, 2017 at 9:59 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
January 12, 2017 at 6: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
January 12, 2017 at 6:28 am
Brandie Tarvin (1/11/2017)
"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
January 11, 2017 at 6:27 am
Brandie Tarvin (1/11/2017)
BLOB EATER (1/11/2017)
GilaMonster (1/11/2017)
I really would like to attend Bits this year (hint, hint)you have my vote!
So someone tell me who those "Steve Jones" and "Grant Fritchey" characters...
"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
January 11, 2017 at 6:15 am
GilaMonster (1/11/2017)
I really would like to attend Bits this year (hint, hint)
DITTO!
(nudge, nudge, wink, wink).
"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
January 11, 2017 at 6:13 am
dave-L (1/5/2017)
I have a active, highly relational, OLTP database
combined with
There are almost no foreign-key constraints defined in the dB
Effectively means that your database is not relational.
but I do not...
"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
January 6, 2017 at 6:20 am
Ah, cool. I wouldn't even have thought to check that.
"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
January 5, 2017 at 5:41 pm
They are certainly not making things easy. The "generic" approach is to use SQL Agent. I have never tried doing this without using Agent or a third party software.
If...
"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
January 5, 2017 at 4:14 pm
Viewing 15 posts - 4,126 through 4,140 (of 22,227 total)