1
kudos
spam Kudos Remove

SQL Server - when to use stored procedures, a big question and think about plan cache?
published 838 days, 5 hours, 17 minutes ago posted by sasa 847 days, 13 hours, 2 minutes ago
Saturday, February 06, 2010 12:20:08 AM GMT Wednesday, January 27, 2010 4:35:07 PM GMT
SQL Server - when to use stored procedures, a big question and think about plan cache?
Every now and then I see this big question from SQL Server users that when to use a stored procedure? Well there is a second part to this question as well, think about caching of such stored procedures There is no such database management software that can guarentee you flawless query execution over a period of time. Performance problems caused by misuse or mismanagement of plan cache, or inappropriate recompilation, can manifest themselves as simply a decrease in throughput or an increase in query...(read more)
category: News | clicked: 0 | | source: sqlserver-qa.net | show counter code
tags: cursor, execution, Maintenance, Monitoring, Performance, plan, SQL Server, stored procedure, tempdb

No comments yet, be the first one to post comment.

To post your comment please login or signup