SQL Performance Archives - Page 72 of 100 - SQL Authority with Pinal Dave

SQL SERVER – Plan Recompilation and Reduce Recompilation – Performance Tuning

February 18, 2010

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

SQL Index, SQL Scripts, SQL Stored Procedure, SQL System Table

Recompilation process is same as compilation and degrades server performance. In SQL Server 2000 and earlier versions, this was a serious issue but in SQL server 2005, the severity of this issue has been significantly reduced by introducing a new feature called Statement-level recompilation. When SQL Server 2005 recompiles stored…

SQLAuthority News – SQL Server Technical Article – The Data Loading Performance Guide

February 17, 2010

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

SQL Data Storage, SQL White Papers

Note: SQL Server Technical Article – The Data Loading Performance Guide by Microsoft The white paper describes load strategies for achieving high-speed data modifications of a Microsoft SQL Server database. “Bulk Load Methods” and “Other Minimally Logged and Metadata Operations” provide an overview of two key and interrelated concepts for…

SQL SERVER – Stored Procedure Optimization Tips – Best Practices

February 16, 2010

Pinal Dave

SQL Performance

Best Practices, SQL Coding Standards, SQL Scripts, SQL Server, SQL Stored Procedure

We will go over how to optimize Stored Procedure with making simple changes in the code. Please note there are many more other tips, which we will cover in future articles.

SQL SERVER – Difference Between Update Lock and Exclusive Lock

February 15, 2010

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Performance, SQL Server, SQL Tips and Tricks

SQL Lock

I have often got this question on this blog as well in different SQL Training. What is the difference between Update Lock and Exclusive Lock? When Exclusive Lock is on any processes no other lock can be placed on that row or table. Every other process have to wait till…

SQL SERVER – Find Statistics Update Date – Update Statistics

January 25, 2010

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

SQL Index, SQL Scripts, SQL Statistics

Statistics are one of the most important factors of a database as it contains information about how data is distributed in the database objects (tables, indexes etc). It is quite common to listen people talking about not optimal plan and expired statistics. Quite often I have heard the suggestion to…

SQL SERVER – Execution Plan – Estimated I/O Cost – Estimated CPU Cost – No Unit

January 22, 2010

Pinal Dave

SQL Performance

Execution Plan, SQL Server

During the SQL Server Optimization training, I enjoy teaching the Execution Plan. I am always sure that questions related to the estimated cost will be raised by attendees. Following are some common questions related to costs:

SQL SERVER – Initializing a Merge Subscription Without a Snapshot

January 15, 2010

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

SQL Replication

During recent course of Disaster Recovery and Performance Tuning, I had very interesting conversation with students regarding Initializing a Merge Subscription Without a Snapshot and Initializing a Transactional Subscription Without a Snapshot. After the discussion when we were looking at MSDN pages one thing caught my notice was the note…