Categories

Index Build strategy in SQL Server - Part 2: Offline, Parallel, No Partitioning

The type of parallel index build plan in SQL server depends on whether or not we have a histogram available with necessary statistics. Therefore, there are two broad categories of parallel index plans: Histogram available: No histogram Histogram available (parallel sort and build): X (Exchange) | \ \ Builder…

Filed under: Database,SQL | On : 2006 Dec 11 | From: SQL Query Processing Team |

IIS services down - "Error parsing XML file. Reason: An invalid character was found in text content" - 4275 Event from IIS Config in the System event log

Crappy ruby script to download photos from a flickr photoset

Similar Posts

Index Build strategy in SQL Server - Part 2: Offline, Parallel, No Partitioning (Non stats plan (no histogram))

Build (serial) (write data to the in-build index) X (Merge exchange) \ Sort Sort Sort (order by index key) Scan Scan Scan(read data from source) When histogram

Index Build strategy in SQL Server - Introduction (I)

Index Build strategy in SQL Server may vary depending on users needs. Each of these Index Build strategies may have different memory and disc space requirement

Index Build strategy in SQL Server - Part 1: offline, serial, no partitioning

Builder (write data to the in-build index) Sort (order by index key) Scan (read data from source) In order to build the b-tree for the index we have to

Index Build strategy in SQL Server - Part 3: Offline Serial/Parallel Partitioning (Aligned partitioned parallel index build)

Aligned partitioned parallel index build In case of parallel build we scan and sort partitions in parallel and the actual number of sort tables existing

Most Popular

How To Group ListView Items with ListViewGroup VB2005

Publishing Reporting Services reports to MOSS

How to bind Generic Dictionary with dropdown list

Parse Comma Delimited TextFile with Visual Basic 2005 TextFieldParser

Using the Active Directory Membership Provider with Forms Authentication in MOSS 2007

Using a parameterized SSIS package as a data source for SQL Reporting Services