SQL Performance Reminders
Just a couple of SQL Server reminders to keep your database skills sharp.
1. Use Fully Qualified Names. This allows SQL Server to better access the stored procedures execution plan and speed up its performance.
EXEC pubs.dbo.reptq1
2. Use SET NOCOUNT ON/OFF. This prevents SQL Server from sending a response to the client indicating the number of rows affected by each statement. Ths helps reduce traffic between the database and the caller.
Here are some great SQL performance articles:
Tuning Tips for Stored Procedures (old but great)
Using Profiler to Identify Poorly Performing Queries
10 Baselining Tips for SQL Server: Lessons From the Field
SQL Server Monitoring in 8 Steps: Lessons From the Field
Comment Notification
If you would like to receive an email when updates are made to this post, please register here
Subscribe to this post's comments using
Comments
What do you think?