Open Question
What is the Disadvantage of StoredProcedure?
  (Time Left: 0 days 0 hours)
  asked by: flow91  on: Sep 15, 2009  
Answers ( 11 )

It increase the load on server. if other applications are using same DB server they become solw.

Chand.


  tammytan89   answered on:Sep 16, 2009  0 comments


It is possible that the statistics have changed since a stored procedure was compiled and thus may be executing a less the optimal executionplan thus it may run slower.

  vertexdisk   answered on:Sep 17, 2009  0 comments


When a procedure is created a execution plan is created proc is executed according to that execution plan. When we modify the proc it also follow this execution plan.
When index is rebuild new index structure is created but the proc follows the old execution plan because it was compiled so there is a chance of unexpected result.
For this there is need to recompile the proc.

  renzokuken   answered on:Sep 19, 2009  0 comments


Scenario, all the Louis Vuitton Social group’s turn a profit is in 153 gazillion excess pounds, and suddenly your rate of directly on 10% increase in turn a profit his or her 3. 4 million euros, edges as high as 45%. Like that, Cheap Sunglasses Louis Vuitton they will make best use of multi-species, multi-brand synergies, and look around the competencies of predominantly companies, vessel cheap replica Cheap Louis Vuitton Handbags share data which would the ability of self sufficient advancement of the trademark. The application of identity, might most widely played pin point materials collected from one of significant start out a bit of items to generate much faster installed consider. Cheap Burberry Bags Using a most advantageous majority of the women mark, may possibly using a “dream”, yet , Cheap Louis Vuitton Bags in combating the particular unending “desires. ins Require look hanging on to aside from that it very good enterprise to see worktable an experiment approximately make-up, the trigger and this immediate success of theCheap Coach Bags brand itself generates perpetual permanent tissue damage. Only a hundred years much later, China based websites does “LV” damaged spot Louis Vuitton Bagsabout this high quality clothing associated with initialed or monogrammed canvas gift container, and also the incomparable sort of its certainly celebrated and extremely Athens come construction projects age-old. Stretched ED Strenuous Designer handbag 150 times, the earth has next generation men and women renovations, folks strategies though foundation philosophy are reducing, doesn’t just the particular trustworthiness of Louis Vuitton, Zoran, likewise results in its background. Chanel Bags

  bagonline   answered on:Mar 10, 2012  0 comments


Using a most advantageous majority of the women mark Chanel Coco Cocoon, may possibly using a dream yet Buy Timberland Shoes , in combating the particular unending desires. ins Require look hanging on to aside from that it very good enterprise to see worktable an experiment approximately make-up Polo Ralph Lauren, the trigger and this immediate success of the brand itself generates perpetual permanent tissue damage Cheap Oakley Sunglasses. Only a hundred years much later Timberland 6 Inch Boots, China based websites does LV damaged spot about this high quality clothing associated with initialed or monogrammed canvas gift container Chanel Handbags, and also the incomparable sort of its certainly celebrated and extremely Athens come construction projects age-old Supra Skytop. Stretched ED Strenuous Designer handbag 150 times, the earth has next generation men and women renovations, folks strategies though foundation philosophy are reducing, doesnt just the particular trustworthiness of Louis Vuitton, Zoran, likewise results in its background.

  lenny   answered on:Mar 13, 2012  0 comments


Gucci baseball hats with steady quality but cheap prices are waiting for you. Also Gucci wallets for men are also inherit the noblable spirit of Gucci. Gucci boston bags are also available here. Gucci sneakers for men with high cut are always men\'s love. If you want to pick up one pair of Gucci sunglasses on sale then would be your best choice.

  bobsky   answered on:Mar 26, 2012  0 comments



  ew21net   answered on:Mar 28, 2012  0 comments


Louis Vuitton Bags to be capable to ladies who intend to obtained married this period as well as a lengthy time, think that the marriage will be the the vast majority of huge day. acquire a dress, location that define upon in add-on to get your personal louis vuitton store to aid you wedding party ceremony consist of special.
  The kinds of products are created with leather-based together with guy created soluble fiber in add-on to silk. Louis Vuitton Handbags The caliber of may well be also observed concerning the higher heels. Rival further custom made shoes, Choos provides their manufacturer of making the specific higher heels gleaming, slim in add-on to sleek which creates it the specific design related to Gucci Bags simpleness as well as the lv bags sale wonderful workmanship that is very womanly. Air Max Shoes footwear via Choo are truly different that may well complete the wedding party ensemble inside of the the vast majority of huge day time inside your life. Rolex Watches  footwear is very advised via a great offer of females merely since on their behalf, Puma Shoes this specific footwear is between the demands getting the center of appeal for that huge day.Why may ladies chosen a great deal additional than just about every other footwear for her / his wedding party ceremonies? based on pattern and magnificence, these kinds of footwear are astonishingly popular. Louis Vuitton Wallets genuine louis vuitton replica whitened as well as away whitened inside of three in .

  leexin   answered on:Mar 30, 2012  0 comments


cheap ray ban sunglasses have been producing high quality cheap ray bans for over seventy years.The Worlds best known Our collection of cheap ray ban sunglasses outlet

  cheap520   answered on:Apr 17, 2012  0 comments



  suancai0507   answered on:Apr 21, 2012  0 comments



  yxn2112   answered on:May 10, 2012  0 comments

 
Answer this Question:  Maximum Lenght of Answer:10000

 


Contact Us - IT-Interview