Viewing 15 posts - 16,111 through 16,125 (of 22,226 total)
gregwhite83 (12/7/2009)
I have a small database that needs upgrading as opposed to making changes to the production database i oftern take a backup and work on it offline. What...
"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 8:06 am
daniel.phone (12/7/2009)
Grant Fritchey (12/7/2009)
daniel.phone (12/4/2009)
star
Please help me with the following questions as soon as possible….
1) True or False, specifying a join hint will force join order?
2) When...
"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 8:02 am
Don't have it in front of me, but it's on the netbook that I'm running it (albeit, very slowly, just needed a place to carry with me for working on...
"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 7:59 am
daniel.phone (12/4/2009)
star
Please help me with the following questions as soon as possible….
1) True or False, specifying a join hint will force join order?
2) When joining two small...
"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 7:02 am
I'm running R2 on Windows 7, no problems. You can.
"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:56 am
In addition to posting the code as Lynn suggests, also try capturing an execution plan or two (more than one if they're changing for each execution).
Two answer part of your...
"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:29 am
S.K. (12/6/2009)
DTS is the true sticking point. Depending on the complexity of the packages, you may have to rewrite them. They won't all work automagically.
I don't think this statement is...
"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:12 am
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
Viewing 15 posts - 16,111 through 16,125 (of 22,226 total)