Views in SQL have a shocking impact on performance (although it is all
relative). If you are trying for performance you should avoid them.
And Michaels SQL tip is... never start a stored procedure with sp_ use
usp_ or anything but sp_. If the server sees a sp_ prefix it looks for
it in the loaded system procedures, then searches the unloaded system
procedures then does a full search of all procedures until it finds it.
©2005 Michael Hawksworth |
