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 |
|
sunil
Constraint Violating Yak Guru
282 Posts |
 Posted - 2006-05-19 : 08:43:32
|
| Recently I was asked few disadvantages of using stored procedure but could not get any. I would like to know if there is/are any disadvantages of SP? |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2006-05-19 : 08:47:08
|
if your data changes a lot then you'd have to recompile a sproc a lot because cached query plans aren't optimal for current data.there's also parameter sniffing look here:http://blogs.msdn.com/khen1234/archive/2005/06/02/424228.aspxcan't think of other downsides...Go with the flow & have fun! Else fight the flow  Blog thingie: [URL="http://weblogs.sqlteam.com/mladenp"] |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
RyanRandall
Master Smack Fu Yak Hacker
1074 Posts |
Posted - 2006-05-19 : 10:51:32
|
| http://www.paladn.com/sql-server-stored-procedures.htmRyan Randallwww.monsoonmalabar.com London-based IT consultancy Solutions are easy. Understanding the problem, now, that's the hard part. |
|
|
|
sunil
Constraint Violating Yak Guru
282 Posts |
Posted - 2006-05-22 : 06:39:40
|
| Thanks all for the posts made. |
|
|
|
|
|
|
What are disadvantages of Stored Procedures?