Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Updates   (RSS)
Thursday, May 15, 2008 9:39 AM

Query Processing Presentation

Last week, I had the opportunity to talk to the New England SQL Server Users Group . I would like to thank the group for inviting me, Adam Machanic for organizing the event, and Red Gate for sponsoring it. My talk was an introduction to query processing,
Posted by craigfr | 0 Comments
Attachment(s): QPTalk.pdf
Wednesday, February 27, 2008 2:05 PM

Halloween Protection

In a prior post , I introduced the notion that update plans consist of two parts: a read cursor that identifies the rows to be updated and a write cursor that actually performs the updates. Logically speaking, SQL Server must execute the read cursor and
Posted by craigfr | 2 Comments
Filed under:
Wednesday, January 30, 2008 1:03 PM

Maintaining Unique Indexes with IGNORE_DUP_KEY

A few months ago, I wrote a post describing how SQL Server maintains unique indexes while avoiding false uniqueness violations. In this post, I'm going to look at how SQL Server maintains unique indexes that were created with the WITH IGNORE_DUP_KEY clause.
Posted by craigfr | 3 Comments
Filed under:
Thursday, September 06, 2007 3:42 PM

Maintaining Unique Indexes

Consider the following schema: CREATE TABLE T (PK INT PRIMARY KEY, A INT, B INT) CREATE INDEX TA ON T(A) CREATE UNIQUE INDEX TB ON T(B) INSERT T VALUES (0, 0, 0) INSERT T VALUES (1, 1, 1) Now suppose we run the following update statement: UPDATE T SET
Posted by craigfr | 5 Comments
Filed under:
Wednesday, August 22, 2007 7:55 AM

Optimized Non-clustered Index Maintenance in Per-Index Plans

In my last post , I showed how SQL Server 2005 only updates non-clustered indexes when the data in the index actually changes. For my example, I used a simple update statement that results in a per-row or narrow plan. In this post, I'll show how this
Posted by craigfr | 5 Comments
Filed under:
Wednesday, August 15, 2007 9:40 AM

Optimized Non-clustered Index Maintenance

Insert, update, and delete plans consist of two parts. The first part or read cursor identifies the list of rows to be inserted, update, or deleted. The second part or write cursor performs the actual insert, update, or delete. Let's look at a simple
Posted by craigfr | 6 Comments
Filed under:
Wednesday, July 25, 2007 2:44 PM

ROWCOUNT Top

If you've looked at any insert, update, or delete plans, including those used in some of my posts, you've probably noticed that nearly all such plans include a top operator. For example, the following update statement yields the following plan: CREATE
Posted by craigfr | 4 Comments
Filed under: ,
Tuesday, May 22, 2007 2:07 PM

Read Committed and Updates

Let's try an experiment. Begin by creating the following simple schema: create table t1 (a int, b int) create clustered index t1a on t1(a) insert t1 values (1, 1) insert t1 values (2, 2) insert t1 values (3, 3) create table t2 (a int) insert t2 values
Posted by craigfr | 7 Comments
 
Page view tracker