Viewing 15 posts - 16,561 through 16,575 (of 22,226 total)
Does the SSIS package do anything besides insert the data? Maybe the statistics are getting updated as well. If not, maybe they need to be.
"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 11, 2009 at 7:37 am
Just a note, right in the upper right hand part of the screen on this web site is a little text box with the label "Search:" to the left of...
"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 11, 2009 at 7:33 am
Jack Corbett (9/11/2009)
Silverfox (9/11/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 11, 2009 at 7:09 am
Jeff Moden (9/9/2009)
Grant Fritchey (9/9/2009)
WHOOP!I'm sitting the same room as Jeff Moden. My IQ has gone up. Who needs a problem sovled?
:blush: Heh... that's odd. I was going...
"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 8:19 pm
WHOOP!
I'm sitting the same room as Jeff Moden. My IQ has gone up. Who needs a problem sovled?
"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 4:43 pm
GilaMonster (9/9/2009)
Grant Fritchey (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:58 pm
It's hard to say for sure, not knowing your queries, your structure or anything about your system.
Probably, those two indexes will work. They both have the same leading edge (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
September 9, 2009 at 1:47 pm
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
Viewing 15 posts - 16,561 through 16,575 (of 22,226 total)