Viewing 15 posts - 17,521 through 17,535 (of 22,226 total)
To eliminate the key lookups you need to make the non-clustered indexes into covering indexes by either adding columns needed to the key or as included columns. But you need...
"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
May 8, 2009 at 8:33 am
Only use nvarchar if you are absolutely going to be using the extended character sets. If you're just using some of the ascii characters with umlauts or whatever, you just...
"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
May 8, 2009 at 8:01 am
One word. Cursors.
"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
May 8, 2009 at 7:00 am
I'm 46 and I think I'm going to try being a geek forever. I'm just not the management type and I really like playing with toys. I know an MS...
"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
May 8, 2009 at 6:15 am
Whoa! I didn't notice that guy had 1200 posts. What the heck is up with that? You take that much time and you still don't get silly fundamentals? And I'm...
"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
May 7, 2009 at 6:24 am
What about good?
What about evil?
What about right?
What about wrong?
Is there a Vorlon in the building?
"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
May 7, 2009 at 6:13 am
Profiler would be my first choice.
Second wouldn't be sp_who2. It'd be sys.dm_exec_requests. With that you can link to other dmv's to get query text, execution plans... whatever you need. But,...
"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
May 7, 2009 at 6:08 am
To heck with google. Open up Books Online. A lot of, most, of the information you need is in there. You don't need to go googling until or unless 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
May 7, 2009 at 6:05 am
Nice job Sylvia,
When you kick up this much mud, you did well.
I do need to disagree with you though. Picking and choosing when to alias or when not to leads...
"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
May 7, 2009 at 5:50 am
RBarryYoung (5/6/2009)
Grant Fritchey (5/6/2009)
Lynn Pettis (5/6/2009)
sorry, crushed you will be.
I don't know. I met Barry at the PASS Summit last year. He sounded a bit like Darth... an avuncular friendly...
"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
May 6, 2009 at 2:59 pm
Lynn Pettis (5/6/2009)
sorry, crushed you will be.
I don't know. I met Barry at the PASS Summit last year. He sounded a bit like Darth... an avuncular friendly Darth, but Darth...
"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
May 6, 2009 at 12:53 pm
Can you run a query against sys.dm_tran_locks? That will give better information. Specifically we need to see the entity_id, the object getting locked.
"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
May 6, 2009 at 12:50 pm
Triggers? Foreign Keys? Rules? Constraints?
There has to be something. You won't get a block... a block, which has a very specific meaning and refers to one process waiting on 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
May 6, 2009 at 12:43 pm
Based on the name, vWorkflowTransition is a view. That means it's probably hitting both tables and maybe 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
May 6, 2009 at 12:34 pm
Alvin Ramard (5/6/2009)
"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
May 6, 2009 at 8:24 am
Viewing 15 posts - 17,521 through 17,535 (of 22,226 total)