| Author |
Topic |
|
gavakie
Posting Yak Master
221 Posts |
 Posted - 2007-09-19 : 11:05:08
|
| Im about to start converting code to Stored Procedures for all my reports in Reporting Services. I was wondering what the pros and cons of this may be. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-09-19 : 11:07:40
|
Pros? Everything.Cons? Nothing.
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-09-19 : 11:11:36
|
| pros: but obviouscons: none if you have version control in place.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
sbalaji
Starting Member
48 Posts |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-09-19 : 14:58:23
|
| I tried googling for Sunset Williams but didn't come up with anything. Perhaps you meant Serena Williams?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-09-19 : 15:20:11
|
"Perhaps you meant Serena Williams?"ROTFL! Different sort of Profession me-thinks ...Reminds me of the old "French military victories" Google search... sadly now fixed  Kristen |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-09-20 : 10:16:49
|
frans is a he  _______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-09-20 : 10:54:28
|
| dynamic plan does get cached. this is much improved in sql server 2005 which even paramterized the cached plan.so in essence the only real advanatage of sprocs is security._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-09-20 : 11:02:50
|
I like to think of a database schema as a class library. the tables are like the private members of those classes, and the procs are the public interface for the class library. some procs may not be accessible from the outside, they are like the private methods of the classes.you wouldn't make all the members of your classes public would you? a good design goal of any piece of software is to have a minimal but complete interface. exposing all table columns is complete, but it's far from minimal.
elsasoft.org |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-09-20 : 11:10:52
|
| the cache is limited by memory.every statement is first parametrized then it's stored in the cache._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
|
|
|
|
Pros and Cons of Using Stored Procedures