Viewing 15 posts - 18,526 through 18,540 (of 22,219 total)
Unfortunately no. We haven't been using the 2008 Wizard for installations, yet. I'll check with our local SSIS guy to see if he has any ideas.
"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
February 3, 2009 at 6:26 am
You want deletes in the transaction log. That's how you can do a rollback if there is a problem. Plus, transaction processing is an essential part of the system maintaining...
"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
February 3, 2009 at 6:19 am
Yep. It can be done. We're using it as part of our migration plan too. I didn't do the setup myself, but I can ask the guy who did 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
February 3, 2009 at 6:17 am
With linked servers I almost always do one of two things. Put the entire load on the linked server, meaning, perform all the joins, etc. on that machine and get...
"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
February 3, 2009 at 6:07 am
Can you post the actual execution plan? Simply looking at a slice of the code we may or may not be able to identify an issue, but looking at the...
"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
February 3, 2009 at 6:04 am
You can use trace events to capture individual statements within a stored procedure. Is that what you're looking for?
"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
February 3, 2009 at 5:59 am
No need to be sorry. Just trying to help. You'll get more eyeballs on your question when it's new if you make it a new post. That's all.
"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
February 3, 2009 at 5:40 am
Jeff Moden (2/2/2009)
Grant Fritchey (2/2/2009)
Jeff Moden (2/1/2009)
Grant Fritchey (1/23/2009)
There are three ways you can do this easily. Use TOP, MAX or ROW_NUMBER.
I'm thinking this one isn't about how to create...
"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
February 3, 2009 at 5:37 am
I can't seem to open the new zip attachment. Sorry.
Looking at the query some more, you've got correlated sub-queries in the select list. This is effectively RBAR (row-by-agonizing-row) processing. Those...
"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
February 3, 2009 at 5:34 am
Lynn Pettis (2/2/2009)
Matt Miller (2/2/2009)
Lynn Pettis (2/2/2009)
Phil Factor (2/2/2009)
Steve, you're supposed to be on holiday!
Typical geek, can't stay away. I should know, I do the same thing here, even...
"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
February 2, 2009 at 10:59 am
I agree MSDN. You might also see if there's an introductory DBA book that has a good chapter on 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
February 2, 2009 at 9:30 am
Unless you're having troubles with the system, I wouldn't recommend changing the PK's on the tables.
That said, int is likely to index a bit better than char(10), so you'll get...
"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
February 2, 2009 at 9:29 am
idrees.butt (2/2/2009)
I really wana read the books but they will be expensive and...
"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
February 2, 2009 at 8:49 am
GilaMonster (2/2/2009)
I'd also recommend T-SQL Fundamentals by Itzik Ben-Gan. I've only glanced through it, but it looks good.
I agree. This is also a very good resource. Thinking about it some...
"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
February 2, 2009 at 8:06 am
idrees.butt (2/2/2009)
Actually I find it always difficult to even understand the topics by which people post their problems. The content is so technical or specific that...
"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
February 2, 2009 at 7:52 am
Viewing 15 posts - 18,526 through 18,540 (of 22,219 total)