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 |
|
binto
Yak Posting Veteran
59 Posts |
 Posted - 2010-01-07 : 00:32:11
|
| Please share tips and steps to improve security and performance of SQL stored proceduresThanks & RegardsBinto Thomas |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-01-07 : 00:39:09
|
| give execute permissions only to authorised memebers. better to create a security role for that in db and assign permissions.For improving performance, analyse the performance by looking into execution plans,profiler and then identify costly steps and fine tune them. |
 |
|
|
|
|
|
Tips to improve security and performance