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 |
|
mikebird
Aged Yak Warrior
529 Posts |
 Posted - 2013-05-03 : 02:04:42
|
| Is it best to put all scripting in stored procedures only (775 at present), or set up views of all commonly-used selections and then SPs use views with parameters?I as told this design before. Any significant performance change? A bit like normalisation - more objects? Currently there are no views. In EXPRESS edition no indexed views |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2013-05-03 : 11:59:50
|
| From a performance standpoint, creating views will not help. Stored procedures will. |
 |
|
|
|
|
|
Optimisation