Viewing 15 posts - 21,136 through 21,150 (of 22,219 total)
You should post this question in the 2000 forum because you may start getting 2005 solutions to the problem that will not work in 2000. For example, I think 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
January 31, 2008 at 5:29 am
How about right clicking in SSMS and then selecting "Script Job as" and "Create to" to arrive at a script that completely replicates the job, schedule and 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
January 30, 2008 at 10:48 am
I agree.
Logically you're defining the join criteria in the ON clause. Based on that criteria, looking at the code, your left join worked perfectly. If you wish to filter...
"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
January 30, 2008 at 10:45 am
Physically, yes. The operate side by side with no issues. Licensing, you need a license for each, you have to trade one license in, or you have to get 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
January 30, 2008 at 9:09 am
I've never heard of anything that'll help. You'll either have to modify the procedure to disable the PRINT statements or you have to modify the code so that it 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
January 30, 2008 at 7:39 am
DonaldW (1/30/2008)
Up the vermin scale from sewer rat to opossum, maybe? :w00t:
Nah, we're still aspiring to reach sewer rat. I'm thinking this will get us from cockroach to water...
"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
January 30, 2008 at 7:11 am
One way:
SELECT t.A1
FROMtest t
JOIN test t2
ON t.A1 = t2.A1
WHERE t.A2 = 1
AND t2.A2 = 4
"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
January 30, 2008 at 7:00 am
DonaldW (1/30/2008)
At the last PASS Summit Gert Drapers said that they are going to try to get a data dictionary feature into the next release of Power Tools.
That will make...
"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
January 30, 2008 at 6:51 am
Please don't cross-post. Especially don't post things in the 2008 forums that has no relation to 2008.
"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
January 30, 2008 at 6:39 am
Oh yeah, do that. The Static Code Analysis tool is a great way to review TSQL. It replaces a lot of the functionality that they dropped from the Best Practices...
"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
January 30, 2008 at 6:38 am
Not knowing much else, I can make too guess. First, the indexes need to be rebuilt or your statistics are out of date. This can lead the optimizer to make...
"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
January 30, 2008 at 6:26 am
Indexes can be, but aren't always, a performance problem when performing ETL. Best answer to that question is for you to test your load both ways, running with the indexes...
"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
January 30, 2008 at 5:28 am
Thanks for confirming Steve. I'd done several searches and hadn't come up with anything.
That is truly sad news.
I thought he was fairly young.
"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
January 29, 2008 at 1:15 pm
Really? Hmm. That actually used to be a specialty of theirs because they were bringing so many people over from ERWin. I haven't upgraded an ERWin model myself since 2002....
"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
January 29, 2008 at 11:57 am
Put me down for Embarcadero ERStudio too. Great tool.
"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
January 29, 2008 at 10:55 am
Viewing 15 posts - 21,136 through 21,150 (of 22,219 total)