Viewing 15 posts - 12,181 through 12,195 (of 22,219 total)
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 needs saying. Just read...
"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:46 am
Lynn Pettis (7/19/2011)
Jeff Moden (7/19/2011)
But a late congrats to Lynn as well.
Dang it. I haven't been keeping up and I've obviously missed something good.
Lynn... what did you do?
My oldest...
"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:45 am
Jeff Moden (7/19/2011)
Grant Fritchey (7/19/2011)
Gianluca Sartori (7/19/2011)
There's someone you all know that deserves your vote here[/url].I'm sure you know who I'm talking about. 😉
I was just coming over to post...
"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:31 am
Nope. Gail said that the two values combined would make a unique index, and they will. They could also be a clustered index. They could also be a primary key...
"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 19, 2011 at 8:42 am
Gianluca Sartori (7/19/2011)
There's someone you all know that deserves your vote here[/url].I'm sure you know who I'm talking about. 😉
I was just coming over to post a comment about someone...
"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 19, 2011 at 8:06 am
Don't confuse primary key and clustered index. I wasn't questioning your PK (although I could, :w00t: ). I like to think about how the data is going to most often...
"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 19, 2011 at 4:50 am
The question for me is, what are you planning on clustering on? Based on your post, I'd suggest the combined index, not the PK, because that sounds like it's 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
July 19, 2011 at 2:54 am
and that's why every database should be stored in source control just like application code.
"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 19, 2011 at 2:49 am
Is the process run nightly and only Sunday failed? If so, like everyone else said, hit the logs and look for the cause. If not, look to the process.
"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 19, 2011 at 2:42 am
Even if it were possible, the differences between them would be essentially the same as between the others.
"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 18, 2011 at 9:00 am
How about normalize appropriately?
For a datawarehouse? I'd suggest looking at a star schema. I'd consider that normalized, but not necessarily in third normal form.
"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 18, 2011 at 8:50 am
AlexSQLForums (7/18/2011)
Grant Fritchey (7/18/2011)
AlexSQLForums (7/14/2011)
it does recommend creating indexes on every column in the where...
"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 18, 2011 at 8:20 am
Jayanth_Kurup (7/18/2011)
If SQL is already compressing the backup then using winzp or winrar doesnt do a great job...
"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 18, 2011 at 5:07 am
AlexSQLForums (7/14/2011)
it does recommend creating indexes on every column in the where clause and depending...
"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 18, 2011 at 2:53 am
You scared me very badly. I can't imagine saying that DTA would do a better job than an experienced DBA.
Personally, I'm extremely underwhelmed by what the DTA delivers. Is it...
"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 18, 2011 at 2:51 am
Viewing 15 posts - 12,181 through 12,195 (of 22,219 total)