Viewing 15 posts - 16,576 through 16,590 (of 22,229 total)
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
crainlee2 (9/5/2009)
I don't think so. I'm running DTA as a server and dba admin with authority to do anything so I don't think that's it but thanks for asking about...
"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:48 am
And just to add to that a bit, shrinking the database is not a method for optimizing performance. It's a little shocking that a vendor is recommending this as 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
September 5, 2009 at 6:17 am
Excellent post sudhanva. Very well summarized. I agree, there are few, if any situations where stored procedures should not be used.
Unfortunately, I need to point out one issue:
sudhanva (9/5/2009)
Not to...
"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 5, 2009 at 6:12 am
Every time I use the DTA I'm impressed by what it misses. Yes, you could try making adjustments to the template and you will get more suggestions, not necessarily good...
"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 5, 2009 at 5:58 am
AllenMWhite (9/4/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 4, 2009 at 11:22 am
Viewing 15 posts - 16,576 through 16,590 (of 22,229 total)