Viewing 15 posts - 14,206 through 14,220 (of 22,219 total)
sql_er (10/4/2010)
1. Subtree cost: Not sure how often people use this, 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
October 4, 2010 at 11:25 am
Jeff Moden (10/4/2010)
Dave Ballantyne (10/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
October 4, 2010 at 8:30 am
Jeff Moden (10/4/2010)
Dave Ballantyne (10/3/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
October 4, 2010 at 6:43 am
Hey Wendy! Excellent editorial. 110% agreement. You really couldn't have put it any better.
BTW, regarding boys & girls & toys, I have twins, one boy, one girl, our intention was...
"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
October 4, 2010 at 6:35 am
It depends on how your views are put together. If they're all simply "SELECT *" type of views, then they more or less fix themselves as they are referenced. On...
"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
October 2, 2010 at 5:26 am
Tim Parker (10/1/2010)
The senior DBA that I work with gave me that idea. So I cheated a bit... 😀
No, no, no. We don't call it cheating. We call...
"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
October 2, 2010 at 4:15 am
Hey guys, thanks for dumping a load of... something into my in box. What the heck were you guys smoking in here last night?
"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
October 2, 2010 at 4:09 am
I really hate the DTA. Piece of Marketing if you ask me.
"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
October 1, 2010 at 1:30 pm
I sure don't have any, but you might search through Brent Ozar's blog[/url]. He's talked about them pretty frequently.
"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
October 1, 2010 at 1:29 pm
Tim Parker (10/1/2010)
In case I completely misunderstood your question, here is a link to BOL that discusses the HOLDLOCK table hint.ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10de_6tsql/html/8bf1316f-c0ef-49d0-90a7-3946bc8e7a89.htm
See if this is what you're looking for.
I 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
October 1, 2010 at 12:05 pm
Tim Parker (10/1/2010)
SQL Server by default should be in pessimistic mode, which should give you the behavior you're looking for without table hints.
True but, they've got snapshot isolation going, which...
"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
October 1, 2010 at 12:04 pm
If they can access row versions through snapshot isolation, you're kind of in trouble. In fact, that's the whole idea of setting up snapshot isolation, allowing access to data while...
"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
October 1, 2010 at 9:07 am
What do the execution plans look like? Just because you put an index on the tables doesn't mean it's being used.
Also, pulling 35000+ rows out of the db 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
October 1, 2010 at 9:02 am
Tim Parker (10/1/2010)
We were fortunate that our Senior DBA was monitoring this server during the time frame of that exception. He was not seeing any CPU pressure during...
"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
October 1, 2010 at 8:48 am
Steve Jones - Editor (10/1/2010)
Grant Fritchey (9/30/2010)
Come on over to my house. I need wood split.
Isn't that your "white oak therapy" time?
Ha! No man, not while swinging a maul or...
"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
October 1, 2010 at 8:46 am
Viewing 15 posts - 14,206 through 14,220 (of 22,219 total)