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 |
|
fmardani
Constraint Violating Yak Guru
433 Posts |
 Posted - 2004-11-01 : 12:41:33
|
| There is a stored procedure which has about 100 parameters. These parameters do get passed on every call to the sp. IS there a way to optimize this sp in sql server 2k?Thanks |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2004-11-01 : 12:44:59
|
the only way to tell is if you show us the sproc...Go with the flow & have fun! Else fight the flow  |
 |
|
|
fmardani
Constraint Violating Yak Guru
433 Posts |
Posted - 2004-11-01 : 12:48:32
|
| My question is not to do with the sql inside the sp but it's to do with the actual sp itself. i.e. is there a better way to pass 100 parameters.Thanks |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2004-11-01 : 12:55:04
|
| well if you need 100 parameters then yes... maybe if u put some defaults, so you don't have to pass them all...Go with the flow & have fun! Else fight the flow |
|
|
|
|
|
|
sp optimization