Viewing 15 posts - 11,716 through 11,730 (of 22,224 total)
Ooh, right, fill factor. Where's my head. Thanks Ninja!
"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 19, 2011 at 6:18 am
What are the 2nd & 3rd highest wait types. Unless you're sure that parallelism is actually a problem on your system (probably evidenced by CPU binding), this is not necessarily...
"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 19, 2011 at 6:15 am
That's an odd one. What version of SSMS are you running and what version of SQL Server is the server itself? You may need to update both.
"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 19, 2011 at 6:13 am
Also, you may want to assess which columns are defining the clustered index. If it's fragmenting that much, maybe you need a different cluster, possibly. Also, you need to evaluate...
"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 19, 2011 at 6:11 am
Pants got to eat, same as worms.
"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 18, 2011 at 1:42 pm
Evil Kraig F (10/18/2011)
SQLRNNR (10/18/2011)
Grant Fritchey (10/18/2011)
Brandie Tarvin (10/18/2011)
Ninja's_RGR'us (10/18/2011)
Brandie Tarvin (10/18/2011)
Ninja's_RGR'us (10/18/2011)
Brandie Tarvin (10/18/2011)
SQLRNNR (10/18/2011)
Must be the force - it's what I was shooting for;-)
I sense a great disturbance...
...oh,...
"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 18, 2011 at 12:33 pm
Brandie Tarvin (10/18/2011)
Ninja's_RGR'us (10/18/2011)
Brandie Tarvin (10/18/2011)
Ninja's_RGR'us (10/18/2011)
Brandie Tarvin (10/18/2011)
SQLRNNR (10/18/2011)
Must be the force - it's what I was shooting for;-)
I sense a great disturbance...
...oh, wait. That was the Blackberry outage....
"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 18, 2011 at 12:15 pm
Brandie Tarvin (10/18/2011)
Ninja's_RGR'us (10/18/2011)
Brandie Tarvin (10/18/2011)
SQLRNNR (10/18/2011)
Must be the force - it's what I was shooting for;-)I sense a great disturbance...
...oh, wait. That was the Blackberry outage. Nevermind.
pre-edit bad pun...
"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 18, 2011 at 10:09 am
ALZDBA (10/18/2011)
Roy Ernest (10/17/2011)
Jack Corbett (10/17/2011)
SQLRNNR (10/17/2011)
Evil Kraig F (10/17/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
October 18, 2011 at 4:36 am
Kiara (10/17/2011)
Grant Fritchey (10/16/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
October 17, 2011 at 6:32 am
WayneS (10/16/2011)
Grant Fritchey (10/16/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
October 16, 2011 at 8:08 pm
BTW, I've just been deleting Thread emails for the last week. It was easier than trying to keep up. Did I miss anything big? Marriages, deaths, taxes, who won 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
October 16, 2011 at 4:45 am
GilaMonster (10/14/2011)
You have GOT to watch this: http://www.youtube.com/watch?v=xC1DIf5hcVw
WHOOP! SQL Chuck Norris makes an appearance... and then some goofball sings about reading plans in the wrong direction.
"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 16, 2011 at 4:42 am
GSquared (10/10/2011)
Stefan Krzywicki (10/10/2011)
Roy Ernest (10/10/2011)
Grant started and I am scared of heckling him... He looks scary.
He's not scary! If worse comes to worse, buy him a beer after 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
October 10, 2011 at 3:22 pm
GSquared (10/10/2011)
Grant Fritchey (10/10/2011)
GSquared (10/10/2011)
GilaMonster (10/10/2011)
Be nice.YOU'VE BEEN WARNED!!!
😀 😛 😛 😀
She's an ED-9000.... You have 15 seconds to comply... 10 seconds... 5 seconds...
The computer is my friend.
The computer wants...
"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 10, 2011 at 12:33 pm
Viewing 15 posts - 11,716 through 11,730 (of 22,224 total)