Viewing 15 posts - 14,521 through 14,535 (of 22,219 total)
First suggestion, follow Gail's advice. Enable traceflag 1222. It will give you a lot of useful information. If you're experiencing lots of deadlocks, usually, it's your TSQL code. It could...
"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 6, 2010 at 6:03 am
Lynn Pettis (8/5/2010)
Well, getting really short here, tomorrow is my last day with my current employer!Wish me luck!!
Excellent! Have fun at the new place and best of luck to you.
"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 6, 2010 at 5:16 am
Steve Jones - Editor (8/5/2010)
Wish me luck. My PASS Board interview is tomorrow. We'll see if I'm still in the running after that.
Best of luck Steve. I don't think you...
"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 6, 2010 at 5:15 am
Also, both types of indexes are ordered logically. Physical ordering is not guaranteed. Regardless though, details are not the issue. 99 indexes is the issue.
"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 5, 2010 at 12:41 pm
You're going to find that Oracle is very difficult to use and maintain without quite a lot of training. SQL Server really is easier. But in the long run, you'll...
"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 5, 2010 at 10:28 am
And if you really want to go to town with it, you should check out Mladen Prajdic's excellent SSMS Tools Pack[/url]. It lets you do a bunch of stuff with...
"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 5, 2010 at 10:26 am
GilaMonster (8/5/2010)
Grant Fritchey (8/5/2010)
Praveen Goud Kotha (8/5/2010)
especially for Fritchey..
If any other reasons for "Reasons for difference in 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
August 5, 2010 at 8:11 am
Right, that last post, that was to a completely different thread... uh, Steve, DBCC Timewarp is acting up or something.
"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 5, 2010 at 7:42 am
Praveen Goud Kotha (8/5/2010)
especially for Fritchey..
If any other reasons for "Reasons for difference in execution plans"..
Please dont forget...
"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 5, 2010 at 7:41 am
jcrawf02 (8/5/2010)
Brandie Tarvin (8/4/2010)
Jack Corbett (8/4/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
August 5, 2010 at 7:40 am
Praveen Goud Kotha (8/5/2010)
especially for Fritchey..
If any other reasons for "Reasons for difference in execution plans"..
Please dont forget...
"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 5, 2010 at 7:35 am
Praveen Goud Kotha (8/5/2010)
GilaMonster (8/5/2010)
Praveen Goud Kotha (8/5/2010)
just confirm me that whether the difference is in no. of parameters or different input data for the procedure..Yes.
??
She means that yes, 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
August 5, 2010 at 6:45 am
GilaMonster (8/5/2010)
Praveen Goud Kotha (8/5/2010)
just confirm me that whether the difference is in no. of parameters or different input data for the procedure..Yes.
What she said.
"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 5, 2010 at 6:37 am
Total agreement on upgrading the hard way. I've only done a few 2008 to R2 upgrades, but they've been seemless to the point of no one noticing. I'd just 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
August 5, 2010 at 6:25 am
Staging tables are frequently a great solution for data import.
Yes, you might get benefits from explicitly updating the stats, especially with a FULL SCAN, or defragging/rebuilding the indexes. It...
"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 5, 2010 at 6:23 am
Viewing 15 posts - 14,521 through 14,535 (of 22,219 total)