Viewing 15 posts - 16,096 through 16,110 (of 22,219 total)
Jack Corbett (12/7/2009)
Bob, you gotta quit changing names. You are confusing me!!!:w00t:
Ha! I didn't even notice the name change. I saw the bio-hazard symbol and knew who it was.
"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:34 am
c-rsiruvur (12/7/2009)
Well I was browsing the Microsoft website and the SqlServer 2005 Enterprise version is not supported on Windows7 Home premium and only the Developer Edition is possible.
Possible. Like I...
"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:33 am
Steve Jones - Editor (12/7/2009)
Can't the DTS packages run with the Runtime in 2005 without modification?
Not everyone we tested. A few barf. Usually when they involve scripting.
"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:31 am
GilaMonster (12/7/2009)
Grant Fritchey (12/7/2009)
Nah, I'm just peeved because of... well, read for yourself.
Oh man. Bob, I LOVE your reply to that thread. What I was thinking, but too polite 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 7, 2009 at 8:30 am
Alvin Ramard (12/7/2009)
Grant Fritchey (12/7/2009)
Alvin Ramard (12/7/2009)
Lynn Pettis (12/7/2009)
Bob Hovious 24601 (12/7/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 7, 2009 at 8:19 am
Alvin Ramard (12/7/2009)
Lynn Pettis (12/7/2009)
Bob Hovious 24601 (12/7/2009)
Now if they had said "Help me with this, please, Expert." that would have been another matter entirely. 😉
Maybe just a extra...
"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:13 am
GilaMonster (12/7/2009)
Hmmm. Just got email from random SSC member. Starts "Help me with this" then goes on for 2 pages. Looked like homework too.Shift-Delete
Got the exact same one. I haven't...
"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:11 am
And, depending on your design, you could skip the whole cursor by granting execute privileges to a particular schema:
GRANT EXECUTE ON someschema TO somerole
"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:10 am
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
Viewing 15 posts - 16,096 through 16,110 (of 22,219 total)