http://www.sqlservercentral.com/Content tagged T-SQL, Performance Tuning, Stored Procedures posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)Stored procedures can be an effective way to handle conflicting needs, but it's not always so obvious how to write them so they both perform well and scale.http://www.sqlservercentral.com/redirect/articles/2838/2008/01/30http://www.sqlservercentral.com/redirect/articles/2838/Stored procedures can be an effective way to handle conflicting needs, but it's not always so obvious how to write them so they both perform well and scale.http://www.sqlservercentral.com/redirect/articles/2838/2008/01/30http://www.sqlservercentral.com/redirect/articles/2838/We've had a lot of coverage of dynamic sql (including another great one from Robert Marda later this week) but this one is a little different. Done in a question/answer format, Andy tries to explain to junior developers why dynamic sql is to be avoided, how to do so, what to do when you can't. http://www.sqlservercentral.com/articles/Performance+Tuning/dynamicsqlorstoredprocedure/969/2005/08/26http://www.sqlservercentral.com/articles/Performance+Tuning/dynamicsqlorstoredprocedure/969/One of the biggest performance gains built into SQL Server is the stored procedure. In this article by Brian Kelley, he shows you how to fully utilize, debug and monitor the caching of such objects. http://www.sqlservercentral.com/articles/Administering/procedurecache/591/2004/11/19http://www.sqlservercentral.com/articles/Administering/procedurecache/591/This article shows you how to identify SQL Server performance problems and explains how the SERIALIZABLE transaction isolation level effected the performance of an OLTP application.http://www.sqlservercentral.com/redirect/articles/931/2003/05/22http://www.sqlservercentral.com/redirect/articles/931/We've had a lot of coverage of dynamic sql (including another great one from Robert Marda later this week) but this one is a little different. Done in a question/answer format, Andy tries to explain to junior developers why dynamic sql is to be avoided, how to do so, what to do when you can't. http://www.sqlservercentral.com/articles/Performance+Tuning/dynamicsqlorstoredprocedure/969/2005/08/26http://www.sqlservercentral.com/articles/Performance+Tuning/dynamicsqlorstoredprocedure/969/A monster book at 980 pages, it's written in 'how-to' format and has a ton of good material. Andy gave it the once over for us and reports back - see what he thinks! http://www.sqlservercentral.com/articles/Installation/reviewofsql2000fastanswers/959/2003/04/18http://www.sqlservercentral.com/articles/Installation/reviewofsql2000fastanswers/959/In this article, James Travis covers a common performance topic of prefixing stored procedures sp_. Does it really slow down performance? http://www.sqlservercentral.com/articles/Performance+Tuning/sp_performance/850/2002/11/14http://www.sqlservercentral.com/articles/Performance+Tuning/sp_performance/850/One of the biggest performance gains built into SQL Server is the stored procedure. In this article by Brian Kelley, he shows you how to fully utilize, debug and monitor the caching of such objects. http://www.sqlservercentral.com/articles/Administering/procedurecache/591/2004/11/19http://www.sqlservercentral.com/articles/Administering/procedurecache/591/In three previous articles Andy has done a very basic introduction to the ADO connection, command, and recordset objects. In this wrap up article he talks about how to use the power of ADO client side filtering and disconnected recordsets, then adds some code which shows how to combine all the objects. ADO is not simple, but Andy has done a good job in limiting his dicussion to the things you REALLY need to know about ADO to get started. http://www.sqlservercentral.com/articles/Performance+Tuning/introductiontoadopart4combiningitall/537/2001/12/07http://www.sqlservercentral.com/articles/Performance+Tuning/introductiontoadopart4combiningitall/537/