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 |
|
devs123
Starting Member
7 Posts |
 Posted - 2008-06-26 : 11:50:57
|
| I was asked this question 'when did you stop fine tuning stored procedure' ? can plz tell me the answer |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2008-06-26 : 11:55:00
|
when you are happy with the performanceor when the customer / user is happy with the performance
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
maninder
Posting Yak Master
100 Posts |
Posted - 2008-06-26 : 11:58:06
|
| "When did you" or was it "when do you" ?Well anyways, no definite answer, you check the performance and Query Plan.Sp is compiled everytime you make changes to it.Even your Query/Tables matter.If the Table Index structure is Efficient, its good to go.I would like to see more discussions.Maninder |
|
|
|
devs123
Starting Member
7 Posts |
Posted - 2008-06-26 : 18:59:32
|
| I was asked this in an interview |
|
|
|
|
|
|
stored procs