THE SQL Server Blog Spot on the Web
Welcome to SQLblog.com - The SQL Server blog spot on the web
Sign in
|
|
in
Page Free Space
(Entire Site)
Search
Home
Blogs
Downloads
Opml
Page Free Space
See also my SQL Server technical articles on SQLperformance.com
Browse by Tags
All Tags
»
Undocumented
»
Performance
»
Page Splits
»
Updates
Deletes
Deletes that Split Pages and Forwarded Ghosts
Can DELETE operations cause pages to split? Yes. It sounds counter-intuitive on the face of it; deleting rows frees up space on a page, and page splitting occurs when a page needs additional space. Nevertheless, there are circumstances
Read More...
Posted
Friday, August 31, 2012 6:09 AM
by
Paul White
|
12 Comments
Filed under:
Updates
,
Undocumented
,
Performance
,
Deletes
,
Page Splits
This Blog
Home
Links
Syndication
RSS 2.0
Recent Posts
Mastering Execution Plan Analysis - Lisbon, Portugal 15 May 2015
Mastering Execution Plan Analysis - Melbourne 6 Feb 2015
SQL Intersection Conference, Las Vegas MGM Grand 10-13 November 2014
Cardinality Estimation for Disjunctive Predicates in SQL Server 2014
Nested Loops Prefetching
Tags
Aggregates
Bugs
Cardinality
Compute Scalar
Conferences
Conversions
Costing
Deletes
DMVs
Expressions
Foreign Key
Halloween Protection
Hash
Heaps
Indexed View
Indexes
Inserts
Internals
Iterators
Joins
LOBs
Lookups
Memory Grant
Merge
Page Splits
Parallelism
Partitioning
Performance
Prefetch
Procedures
Query Optimizer
Query Plans
Ranking functions
Row Goal
Scans
Seeks
Segment
Sequences
Sorting
Spool
Statistics
Temporary Tables
Top
Trace Flags
Transformations
TSQL
Undocumented
Updates
Work Tables
News
SQL Server MVP 2011-2014
Rockstar Blogger
Archives
January 2015 (1)
November 2014 (1)
August 2014 (1)
April 2014 (1)
August 2013 (2)
June 2013 (2)
March 2013 (2)
February 2013 (3)
January 2013 (1)
December 2012 (1)
October 2012 (1)
September 2012 (2)
August 2012 (3)
May 2012 (2)
April 2012 (3)
March 2012 (1)
January 2012 (1)
December 2011 (3)
September 2011 (1)
August 2011 (3)
July 2011 (4)
June 2011 (1)
March 2011 (1)
February 2011 (6)
December 2010 (2)
November 2010 (2)
October 2010 (1)
September 2010 (2)
August 2010 (7)
July 2010 (8)
©2006-2016 SQLblog.com
TM
Brought to you by
A.M.
&
Peter DeBetta
Privacy Statement