Articles

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)

2002-02-26

22,206 reads

AdeptSQL Workshop released

Adept SQL Tools has released AdeptSQL Workshop, an IDE for SQL-based database schema creation and management. Includes fast drag'n'drop SQL decompiler, editor, preprocessor, SQL analyzer and difference engine, "revision history" scripts with a separate player utility for remote db deployment, integration with MS Visual SourceSafe. Pricing starts at $130,
$199 with VSS support.

2002-02-25

3,342 reads

Blogs

Lock your Azure SQL Database

By

So you have many databases in Azure, you accidentally deleted one which can happen...

BlitzFileStats custom module available for Inspector V2

By

BlitzFileStats is the latest addition to our custom module collection for reporting on data...

Fun Fact: AWS RDS and system_health

By

Did you know that the system_health Extended Event session was running in your RDS...

Read the latest Blogs

Forums

Order Atenolol jelly, Order atenolol super force over the counter

By stanley

Order Atenolol jelly, Order atenolol super force over the counter Our online pharmacy is...

Changing Connection Managers with the Configuration Manager

By Thom A

OK, this actually not a question, this is in response to a question I...

SSIS How to split a single string into multiple columns using Derived Column

By sabarishbabu

Hello, In my source Column having comma separated with text qualifier(“), I would need...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers