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 |
|
kmurlikrishna
Starting Member
23 Posts |
 Posted - 2007-02-24 : 02:17:14
|
| 1) We have SQL Server 2005 on windows 2003 server.2) We have views on tables without any READ (UNCOMMITTED) table hint.3) In our stored procs, we use only these views in all queries & READ (UNCOMMITTED) is allowed for them as well.4) Will it have effect? Will this hint percolate to all the tables in joins in FROM clause of the view definition? If not do we place this hint against all the tables in all the views as well?5) OR is it better to just have this table hint against all the tables themselves in theview definition itself? |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2007-02-24 : 02:39:46
|
| what problem are you trying to solve? do you understand the ramifications of using this hint?-ec |
 |
|
|
|
|
|
Views Tables READ (UNCOMMITTED)