Analyzing and Optimizing T-SQL Query Performance on SQL Server

Additional Articles, 2003-03-14

Rate

2.5 (2)

Share

Share

Rate

2.5 (2)

Related content

Making Dynamic Queries Static

Building and executing dynamic sql in a stored procedure – is it the only way to solve problems like supporting a simple search function? Leon offers a couple alternatives that let you continue to provide the functionality in a stored procedure without using dynamic sql. Interesting ideas worth exploring!

1 (2)

Leon Platt

2002-05-02

12,880 reads

Optimizing Stored Procedures To Avoid Recompiles

One of the most overlooked areas in optimizing SQL Server and Transact-SQL is the recompilations of stored procedures. A database getting thousands of recompiles an hour will suffer in performance and show short term blocking that will affect the database users. This article by Randy Dyess shows you some of the ways you can avoid stored procedure recompiles.

3.67 (3)

Randy Dyess

2002-02-26

21,086 reads