Viewing 15 posts - 12,031 through 12,045 (of 22,219 total)
Hold a second. TableB has an identity column. You can't make that a foreign key to another table, it will cause errors because, in theory, you're creating values automatically in...
"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
August 19, 2011 at 7:02 am
skrilla99 (8/19/2011)
Grant Fritchey (8/19/2011)
skrilla99 (8/19/2011)
SELECT dtat.transaction_begin_time,
dtat.transaction_status,
dtat.transaction_state,
...
"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
August 19, 2011 at 6:27 am
skrilla99 (8/19/2011)
SELECT dtat.transaction_begin_time,
dtat.transaction_status,
dtat.transaction_state,
der.blocking_session_id,
...
"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
August 19, 2011 at 6:12 am
This will get you started[/url].
"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
August 19, 2011 at 5:42 am
Here's an introduction to the topic[/url].
"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
August 19, 2011 at 5:41 am
Jeff Moden (8/18/2011)
"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
August 19, 2011 at 5:03 am
Eugene Elutin (8/19/2011)
Jeff Moden (8/18/2011)
"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
August 19, 2011 at 5:00 am
I would focus on the query, the code, not the ANSI settings. That is, unless you have an identical query with a different set of ANSI settings and you're getting...
"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
August 19, 2011 at 4:58 am
EjSQLme (8/18/2011)
Grant Fritchey (8/17/2011)
"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
August 18, 2011 at 4:12 pm
GilaMonster (8/18/2011)
Jim Murphy (8/18/2011)
"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
August 18, 2011 at 5:46 am
If you recreate it with a smaller size, I think that's what you're looking 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
August 18, 2011 at 5:31 am
DISTINCT is an aggregation. Will it always increase execution time? No, but it frequently does. It's usually put in as a crutch because someone doesn't know how to properly write...
"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
August 18, 2011 at 5:15 am
Just can't tell you a thing beyond what Jeff has suggested without seeing the execution plan.
Numeric 19,0? Not an integer or a bigint? Is that data type the same as...
"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
August 18, 2011 at 5:11 am
It sounds like you've hit a regression. These are edge cases where a query that, honestly, should have run slow in 2000, didn't. But now, it does. Every edge case...
"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
August 18, 2011 at 5:08 am
The conversation bounced around a bit, but it sounds like you could use three things. First, and most importantly, a well documented development & deployment method that you can enforce...
"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
August 18, 2011 at 5:02 am
Viewing 15 posts - 12,031 through 12,045 (of 22,219 total)