SqlShare.com Logo
 
Skip Navigation Links
Home
Video List
Events
Classes
About Us
Login / Register
Subscribe RSS Feed 

Takes Query Plan Analysis and Performance Monitoring to a New Level

Delete Statement Operators

Deleting rows from a table isn't always as simple as you might expect. This video by performance guy Grant Fitchey shows you want a delete looks like in a query plan and also shows you an example of what happens when there are foreign keys defined on the table.

Duration:
1 mins 18 secs
Skill Level:
100
Rating:
4.06 out of 5
Publish Date:
September 09, 2008
Delete Statement Operators You must be logged in to view this video.  
Bookmark and Share
 
1=Poor, 3=Good, 5=Excellent

About the Author

Image of Grant Fritchey
I'm currently working for FM Global, an industry leading engineering & insurance company, as a DBA. I've done development of large scale applications in languages such as VB, C# and Java. I've worked in SQL Server from the hoary days of 6.0. My nickname at work is the "The Scary DBA." I even have an official name plate with it. I wear it proudly. I was awarded a Microsoft MVP in April of '09.

References

There are no downloads or recommended reading links for this video

Comments
Venkata Taduri on 2/24/2009
Awesome.

bc on 3/26/2009
interesting, never thought about what all goes on under the covers.

John Vanda on 3/26/2009
Excellent explanation of the complexity involved behind the scenes on something that appears simple

Lonnie Meinke on 3/26/2009
A little more setup would have been helpful.

Robert McCormick on 8/22/2011
How do I use this information for more efficient deletes?

Dennis Allen on 8/22/2011
I am a little fuzzy on the quiz stating that the clustered index delete is an operator...

1668EAAE79 on 8/22/2011
Interesting, would have liked to have seen more detail.

MyDoggieJessie on 8/22/2011
would like to see a series of videos on query plans

Leon on 8/22/2011
Interesting, but not very useful to me

Nilesh on 8/22/2011
nice

John O'Sullivan on 8/22/2011
a great tip

5124CFD2E1 on 8/23/2011
Little confused. The clustered delete operator indicates that a delete occurred. However, in reality the delete did not occur until the assert operator verifies. The actual delete will occur once the assert operator verifies that the FK constraints are not violated. Hence the reason for my answer.

Terrance on 8/27/2011
Could have been more informational.

Maurice Ivory on 1/18/2012
It went just a little too fast for me...need about 1 more minute to explain the topic.

juissi on 2/20/2012
I have a question. How I can delete automatically all rows after I execute report. I want clear the table when the raport is generated



Must Be Logged In
 

How Do I Become a Video Author? |  Newsletter History

Copyright © Fourdeuce, Inc., 2005-2009. All Rights Reserved | Privacy Policy | Terms & Conditions