Viewing 15 posts - 12,166 through 12,180 (of 22,219 total)
David Burrows (7/26/2011)
Grant Fritchey (7/26/2011)
Yeah, luckily I'm behind on preparing my morning coffee...
After meeting you, don't know why but it conjures up an image of you in a pinny...
whoa! too...
"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
July 26, 2011 at 7:24 am
Gianluca Sartori (7/26/2011)
Grant Fritchey (7/26/2011)
"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
July 26, 2011 at 5:59 am
Can't help it, I have to share. I was doing some Boogling or Ginging, whatever we call it now, when I stumbled across a really scary bit of advice. It'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
July 26, 2011 at 5:35 am
Ninja's_RGR'us (7/21/2011)
Grant Fritchey (7/21/2011)
Have you tried using extended events. I'm know you can filter better there.I'm on SQL 2K5. And apparently those features is new on sql 2K8.
sorry, I...
"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
July 21, 2011 at 10:41 am
Have you tried using extended events. I'm know you can filter better there.
"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
July 21, 2011 at 10:32 am
I'd strongly suggest looking into the concept of data normalization. I'm not sure what business case this table is answering, but I'm positive it could be better met through relational...
"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
July 21, 2011 at 4:55 am
I'd suggest you download a copy of SQL Monitor[/url] from Red Gate software. Based on the list of monitoring needs you think you have I think it might be 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
July 21, 2011 at 4:51 am
There are several white papers available from Microsoft on how to configure your tempdb, but from the sounds of things it might not help. Pre-sizing is good, but it might...
"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
July 21, 2011 at 3:01 am
GilaMonster (7/20/2011)
Grant Fritchey (7/20/2011)
It can only be people who chose to register for one of those other pre-cons... THOSE people.
So at tea break, we run into Rob's session work 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
July 20, 2011 at 9:57 am
The Dixie Flatline (7/20/2011)
GilaMonster (7/20/2011)
Ninja's_RGR'us (7/20/2011)
GilaMonster (7/20/2011)
Jeff Moden (7/20/2011)
I understand that Gail Shaw will be co-presenting with you...
Yup, Grant and I are doing comed^H^H^H^H^H execution plans as a precon...
"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
July 20, 2011 at 9:45 am
I really like that picture... well, the left side of it anyway.
"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
July 20, 2011 at 9:35 am
Jeff Moden (7/20/2011)
Grant Fritchey (7/20/2011)
All joking aside, I'd love to see you win this one.
I never did read what the winner would be awarded before the folks at work nominated...
"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
July 20, 2011 at 9:30 am
Based on what you describe, yeah, you're better off with temp tables. Although, how were the physical tables indexed? Did you put a cluster on the SPID column? There's 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
July 20, 2011 at 7:04 am
Also keep in mind that those costs are estimates based on statistics, not actual execution time for your server.
Look at the execution times, the number of scans and the number...
"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
July 20, 2011 at 6:57 am
Lynn Pettis (7/20/2011)
Grant Fritchey (7/20/2011)
Jannie-186227 (7/20/2011)
ahem.How do you reply to a thread with 23 thousand replies?
Is there any more value to be added in this thread?
Cheers
Jannie
In this space, say whatever...
"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
July 20, 2011 at 12:53 am
Viewing 15 posts - 12,166 through 12,180 (of 22,219 total)