Viewing 15 posts - 16,561 through 16,575 (of 22,219 total)
shane.barney (9/9/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
September 9, 2009 at 1:41 pm
Oh, hey, Gail, I almost forgot. I remembere, barely, got to it during the Q&A, to put in a reference to the fiber optic laser beam assembler during 24 Hours...
"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
September 9, 2009 at 1:23 pm
Steve Jones - Editor (9/9/2009)
Day 365
Excellent! You should have that big grin on your face. Good job. I'm impressed.
Did you run even when you were sick? Or are you 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
September 9, 2009 at 1:17 pm
Luke L (9/9/2009)
"Species breeding in more tropical areas are often more sedentary, although several tropical species are partial migrants or make shorter migrations."
The pic on the left...
"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
September 9, 2009 at 12:27 pm
It really depends on the situation in which you are receiving it. Is the server just starting up? Then almost every single query call is going to be a cache...
"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
September 9, 2009 at 12:05 pm
stewartc (9/9/2009)
My recommendation then:clustered index on ClientID, non clustered index in the GUID.
ClientID is a GUID.
"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
September 9, 2009 at 7:42 am
Funny enough, this video was just posted today:
http://www.sqlshare.com/showitem.aspx?id=BD9AAED9-6B7D-4979-ADD5-33436716CCAF
That will show you what the others have described.
"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
September 8, 2009 at 9:32 am
PiMané (9/8/2009)
Right now...
"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
September 8, 2009 at 7:56 am
Oh, and yes, you should have a clustered index on most of your tables (most being 99.9999999999%) or have a very good reason why not, with testing and good documentation....
"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
September 8, 2009 at 6:57 am
All the testing I've done with GUID's as a clustered index have shown some serious performance problems. The one thing that alleviates this somewhat is to use the SEQUENTIALID mechanism....
"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
September 8, 2009 at 6:56 am
Yes = Laptop, Desktop, Books, Drivers License
No = everything else.
How on earth do you function as a DBA, let alone post on SSC without a desktop or a laptop? 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
September 8, 2009 at 6:40 am
Andrew Watson (9/7/2009)
When faced with a problem like this, my brain automatically went into "performance problem" mode, and since these generally occur with big datasets, 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
September 7, 2009 at 8:07 pm
Paul White (9/7/2009)
Grant Fritchey (9/7/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
September 7, 2009 at 7:58 pm
Paul White (9/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
September 7, 2009 at 6:30 am
When you say it failed to update, do you mean that it returned an error or that the query ran fine, but no data was updated?
There has to be an...
"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
September 6, 2009 at 5:53 am
Viewing 15 posts - 16,561 through 16,575 (of 22,219 total)