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
Deletes
Query Plans
Updates
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
Can a SELECT query cause page splits?
Books Online has this to say about page splits: When a new row is added to a full index page , the Database Engine moves approximately half the rows to a new page to make room for the new row. This reorganization is known as a page split .
Read More...
Posted
Tuesday, August 30, 2011 7:46 AM
by
Paul White
|
6 Comments
Filed under:
Query Plans
,
Undocumented
,
Performance
,
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