Viewing 15 posts - 15,841 through 15,855 (of 22,219 total)
You can get different execution plans if the connection settings are different. Check the ANSI settings in particular.
"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
February 10, 2010 at 5:44 am
Based on the query, you're probably getting pretty severe table scans. But I agree with the previous post, make sure your statistics are up to date.
Can you post the execution...
"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
February 10, 2010 at 5:42 am
David Portas (2/10/2010)
Grant Fritchey (2/10/2010)
Without the trigger and in the arc design, it's possible to have a comment be designated for more than one object
Not if you use a compound...
"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
February 10, 2010 at 5:23 am
David Portas (2/10/2010)
Grant Fritchey (2/10/2010)
"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
February 10, 2010 at 5:12 am
Dave Winchester (2/10/2010)
Thanks for the reply. Your explanation has helped me (mentally) greatly. I understand the Person/Location etc...relationship better now.
With regards to my problem of the Comments tables 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
February 10, 2010 at 4:29 am
weitzera (2/9/2010)
They have identical costs in the query plan.
Yeah, they frequently do. You have to remember that costs in query plans are just estimates, not real numbers. They can 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
February 10, 2010 at 4:20 am
I'm on board with Welsh Corgi, make sure you're testing your backups.
Other than that, it seems like a reasonable plan. I'd just run the log backups for 24 hours though....
"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
February 10, 2010 at 4:03 am
Roy Ernest (2/9/2010)
This is the first time I got insulted here. Feels kind of strange... But what ever.....
"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
February 10, 2010 at 3:50 am
With the Contacts, Addresses, etc., it's a different thing than the original arc. You're talking about a person. To quote, Suess, a person is a person. You don't need to...
"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
February 10, 2010 at 3:40 am
Andy Leonard (2/8/2010)
This reminded me of the demise of my checklist. I used to think database tuning was a matter of checking off items on my checklist, 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
February 8, 2010 at 8:04 am
GilaMonster (2/8/2010)
"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
February 8, 2010 at 7:42 am
I'm a little surprised that you're not recommending running CHECKDB on the database in question. Yes, it's marked as suspect, and yes, you might find a cause in the error...
"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
February 8, 2010 at 7:22 am
Tobar (2/8/2010)
Each person must assess their own needs and responses when considering "cookie cutter" numbers. As much as we would like to believe, we are not a one size...
"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
February 8, 2010 at 7:00 am
Alvin Ramard (2/5/2010)
Grant Fritchey (2/5/2010)
Please tell me you did that from memory.Don't you mean that I did NOT do that from memory?
No, no. I think it would be much more...
"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
February 5, 2010 at 11:49 am
Please tell me you did that from memory.
"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
February 5, 2010 at 11:44 am
Viewing 15 posts - 15,841 through 15,855 (of 22,219 total)