Viewing 15 posts - 16,126 through 16,140 (of 22,232 total)
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
I generally prefer several smaller tools that do jobs really well. Take for example type ahead. It's built into SSMS, but it stinks. Get a copy of Red Gate SQL...
"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:39 am
So you've got identical execution plans on identical databases on the same server, but one is running slow and the other is not?
Contention is the first thing that comes 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
December 3, 2009 at 12:43 pm
Viewing 15 posts - 16,126 through 16,140 (of 22,232 total)