Viewing 15 posts - 16,111 through 16,125 (of 22,219 total)
Lynn Pettis (12/7/2009)
davidandrews13 (12/7/2009)
i dont think it makes to much difference in this situation because its currently only bringing...
"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
December 7, 2009 at 6:09 am
GilaMonster (12/4/2009)
arr.nagaraj (12/4/2009)
So i felt it should beNCIndex key + Included column( which includes cluster) + cluster key
SQL's not stupid enough to store 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
December 5, 2009 at 7:47 am
Just be aware that dynamic SQL can lead to the exact same types of problems you were facing with this procedure. It's worth knowing ahead of time. The one way...
"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
December 5, 2009 at 7:37 am
GilaMonster (12/4/2009)
Dan H. (12/4/2009)
I've seen excerpts of Kalen's book (it does look excellent), but does it relate to SQL Server 2005?
The title's actually Inside SQL Server 2005: The Storage Engine....
"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
December 4, 2009 at 1:24 pm
If I understand the question, the best resource I know for this is Kalen Delaney's book: Inside SQL Server 2008: The Storage Engine. Absolutely fantastic.
"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
December 4, 2009 at 12:30 pm
They're from the DTA and because of that, I'd test the heck out of them to validate that they need to be there. The DTA is not to be trusted....
"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
December 4, 2009 at 12:22 pm
timothyawiseman (12/4/2009)
Grant Fritchey (12/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
December 4, 2009 at 12:08 pm
GilaMonster (12/4/2009)
Only three?
For this 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
December 4, 2009 at 8:08 am
Jeff Moden (12/4/2009)
Grant Fritchey (12/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
December 4, 2009 at 7:38 am
GSquared (12/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
December 4, 2009 at 6:56 am
GilaMonster (12/4/2009)
Grant Fritchey (12/4/2009)
More, absolutely more. The key values plus the include values plus the clustered key, it has to add up to more.
Depends what the key is. If...
"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
December 4, 2009 at 6:53 am
ChiragNS (12/4/2009)
GrantDoes the default trace show delete statements?
Nope. Sorry. Stupid statement. It tracks errors & objects created/deleted, that sort of thing.
"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
December 4, 2009 at 6:46 am
Great primer Barry. It covers the basics of what's needed very well. Since so many questions come through on the board around the concept of "How do I get started...
"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
December 4, 2009 at 6:01 am
GilaMonster (12/4/2009)
sashikanta.mishra (12/3/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
December 4, 2009 at 5:55 am
Manie Verster (12/3/2009)
Per example
Password expiry period = 3 months
Password lock out = 3 failures
Strong password required = true
Now I know that by default SQL Server uses...
"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
December 4, 2009 at 5:52 am
Viewing 15 posts - 16,111 through 16,125 (of 22,219 total)