Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jonathans
Starting Member
40 Posts |
 Posted - 2006-07-06 : 07:20:23
|
| Hey guysI am just curious to know if there is a performance knock (Im assuming there is) on retrieving data from one DB to another.ie. SELECT [ID] FROM [Database2].[dbo].[MyTable] where we are currently calling from [Database1].Also noted is that the physical DB files are located on the same HD (raided/single drive).Thanks In Advance...JWARNING: Running on cold coffee! |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-07-06 : 07:43:31
|
| Not a lot - it has to check permissions but that's about it.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
jonathans
Starting Member
40 Posts |
Posted - 2006-07-06 : 08:31:58
|
| Sweet, thanks for the confirmation :)WARNING: Running on cold coffee! |
|
|
|
|
|
|
Is there a performance knock?