Viewing 15 posts - 14,521 through 14,535 (of 22,224 total)
For me, the question is, one database or many, why are you splitting them? Do you have different applications with different sets of users and different sets of data and,...
"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:47 am
Always remember, if you're in doubt of anything, test it. For an update query like this, I'd suggest wrapping it in a BEGIN TRAN and ROLLBACK TRAN and seeing how...
"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:45 am
CavyPrincess (8/5/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 6, 2010 at 6:43 am
Since you're asking, I'll come right out & say it, look at my signature line and try my book on performance tuning.
In addition, I'd strongly recommend getting Itzik Ben-Gan's...
"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:42 am
Dynamic Management Views (DMV) to the rescue!
Look up in BOL sys.dm_tran_*. You'll find more information than you can shake a stick at. You can combine this with other DMVs like...
"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:35 am
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
Viewing 15 posts - 14,521 through 14,535 (of 22,224 total)