Viewing 15 posts - 19,291 through 19,305 (of 22,226 total)
Ah, true, I hadn't thought about that. Still, the execution plan can point out where an index might help. He might be able to use a plan guide but I'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
November 23, 2008 at 8:00 am
The DTA can be a somewhat useful tool, but it's not terribly reliable.
Do you have an execution plan for the query? That would help identify what's occuring within your system.
First...
"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
November 23, 2008 at 7:42 am
Jeff Moden (11/23/2008)
Grant Fritchey (11/23/2008)
"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
November 23, 2008 at 7:19 am
GilaMonster (11/22/2008)
Jack Corbett (11/22/2008)
Glad it was packed out Gail.
It wasn't completely packed out. There were empty seats. I'd say the room was 50-60% full. Bob Ward's session 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
November 23, 2008 at 7:10 am
GilaMonster (11/22/2008)
Jeff Moden (11/22/2008)
But none of us has written a book like some of the good folks we know. 😉And he's writing another one. A full, published dead-tree book...
Re-writing one....
"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
November 23, 2008 at 7:05 am
Jeff Moden (11/22/2008)
GAAAA!!!http://www.sqlservercentral.com/Forums/Topic606992-65-1.aspx
And yet, there is Gail, answering his questions... Amazing. I wouldn't even bother with a response on one like that.
"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
November 23, 2008 at 7:02 am
I'm too busy to learn how to keep the log from growing? No. I'm actually not too busy to learn that one. I'm too busy to learn how to figure...
"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
November 23, 2008 at 6:52 am
Jeff Moden (11/22/2008)
"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
November 23, 2008 at 6:50 am
Jeff Moden (11/22/2008)
"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
November 23, 2008 at 6:43 am
Jack Corbett (11/22/2008)
Grant Fritchey (11/22/2008)
Terribly late to the party, rude of me, I know.
Better late than never. Oh, and based on your tweets it didn't seem like you were...
"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
November 22, 2008 at 8:50 am
Hey Jeff,
Just curious, I was thinking about it, and, you know, I was wondering, have you got a good, you know efficient, way to clear a table?
All my love,
Grant
"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
November 22, 2008 at 8:35 am
Oh, and one more.
On the URGENT posts. My favorites are the ones where you post a possible answer to the question with five minutes of the OP, but you don't...
"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
November 22, 2008 at 7:36 am
Terribly late to the party, rude of me, I know.
I agree with Steve, it seems to come in waves. It is a bit shocking that people think that posting a...
"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
November 22, 2008 at 7:33 am
Congratulations and very well done. That looked like serioulsy tough competition.
"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
November 22, 2008 at 7:19 am
That was just a typo. Sorry about about the confusion. The script is right and the text is slightly off.
"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
November 21, 2008 at 6:59 am
Viewing 15 posts - 19,291 through 19,305 (of 22,226 total)