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 |
|
Eagle_f90
Constraint Violating Yak Guru
424 Posts |
 Posted - 2007-12-17 : 20:21:53
|
| I was wondering if I log into a DB under a reader only account is it a performance gain to call a table via it's full name (DBOwner.TableName) instead of just the table name?-- If I get used to envying others...Those things about my self I pride will slowly fade away.-Stellvia |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-12-17 : 21:20:16
|
| On the contrary, irrespective of how you login, calling an object with its owner name is advised. So SQL Server doesnt have to do the name resolution.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
Eagle_f90
Constraint Violating Yak Guru
424 Posts |
Posted - 2007-12-18 : 00:14:11
|
| Cools, I will remember to call by full name even when logging in as DBO-- If I get used to envying others...Those things about my self I pride will slowly fade away.-Stellvia |
|
|
|
|
|
|
Full Table Name performace?