Viewing 15 posts - 14,551 through 14,565 (of 22,219 total)
No, you can't do that. Not that way. A variable is just a place holder and is not resolved into TSQL on the fly. What you can do, and 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
August 4, 2010 at 6:36 am
Jeff Moden (8/4/2010)
Grant Fritchey (8/4/2010)
"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
August 4, 2010 at 6:30 am
Brandie mentioned SSIS, which is SQL Server Integration Services. It's the built-in SQL Server ETL (Extract/Transform/Load) tool. She was suggesting that if they could deal with day old data, 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
August 4, 2010 at 6:29 am
The max degree of parallelism and having multiple files for your tempdb are not directly related. One has to do with file storage, the other has to do with how...
"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
August 4, 2010 at 6:22 am
If they need live access you just have to set up a connection either direct through ADO (or whatever) or using another tool such as the Oracle Gateway (it used...
"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
August 4, 2010 at 6:20 am
DealerID is being supplied from the original file, right? That's where you get it. Presumably you can join back to the original file with the address information 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
August 4, 2010 at 5:30 am
Steve Jones - Editor (8/3/2010)
Jack Corbett (8/3/2010)
WayneS (8/3/2010)
What do you'll think about this[/url]? Is there a valid...
"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
August 3, 2010 at 12:55 pm
It is possible, just thinking about it, for the NULL values to mess you up though. An ORDER BY statement that is working on NULL values could get those values...
"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
August 3, 2010 at 12:39 pm
Are you sure the data is the same between the servers? ORDER BY should work the same way, regardless of NULL values. Maybe the databases have different collation settings? 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
August 3, 2010 at 12:17 pm
You should look at the OUTPUT clause. You can use that to capture the ID's generated for all the addresses you just inserted.
"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
August 3, 2010 at 11:48 am
You need to determine what "locked up" means. It could be that the procedure recompiled with a bad plan and the queries are running slow, or it could be contention....
"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
August 3, 2010 at 11:42 am
Stefan Krzywicki (8/3/2010)
Grant Fritchey (8/3/2010)
Stefan Krzywicki (8/3/2010)
Brandie Tarvin (8/3/2010)
Greg Edwards-268690 (8/3/2010)
Hope those in the northern regions have clear skies for the possilbe light show tonight.
Light show?
The Northern Lights or meteor...
"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
August 3, 2010 at 11:27 am
WayneS (8/3/2010)
What do you'll think about this[/url]? Is there a valid point? Are the people screaming about...
"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
August 3, 2010 at 11:26 am
Stefan Krzywicki (8/3/2010)
Brandie Tarvin (8/3/2010)
Greg Edwards-268690 (8/3/2010)
Hope those in the northern regions have clear skies for the possilbe light show tonight.Light show?
The Northern Lights or meteor shower?
Meteor shower. Scroll down...
"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
August 3, 2010 at 11:16 am
Greg Edwards-268690 (8/3/2010)
So totally off topic -Hope those in the northern regions have clear skies for the possilbe light show tonight.
Greg E
Ditto. We'll be out at a Scout event. It'll...
"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
August 3, 2010 at 11:14 am
Viewing 15 posts - 14,551 through 14,565 (of 22,219 total)