THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Partitioning   (RSS)
  • Public Release, SQL Server File Layout Viewer

    Version 1.0 is Now Available! Edit 9 October 2013: A new version is out! Please download 1.2 from here.  I’ve been working off and on, as my real job permits, on this visualization tool for SQL Server data files. This is an educational or exploratory tool where you can more readily see how the individual data pages in MDF/NDF files are ...
    Posted to Merrill Aldrich (Weblog) by merrillaldrich on March 1, 2013
  • Updated Warehouse Re-Index Script

    As I talked about in my last post, I just went through a re-indexing project that took the partitioned fact rows from our warehouse and relocated them into new files. There are a lot of tables and indexes involved, so I have a PowerShell “helper” script to generate the actual T-SQL that moves the data. The idea is to find all the indexes that use ...
    Posted to Merrill Aldrich (Weblog) by merrillaldrich on January 14, 2013
  • Why Doesn’t Partition Elimination Work?

    Given a partitioned table and a simple SELECT query that compares the partitioning column to a single literal value, why does SQL Server read all the partitions when it seems obvious that only one partition needs to be examined? Sample Data The following script creates a table, partitioned on the char(3) column ‘Div’, and populates it with ...
    Posted to Page Free Space (Weblog) by Paul White on September 11, 2012
  • sys2 scripts updated

    I’ve updated my “sys2” scripts with three 3 new scripts: sys2.objects_dependencies A wrapper around sys.sql_expression_dependencies that shows also related informations taken from sys.object table, like object name, object type and schema name of the referencing entity. sys2.objects_partition_ranges Shows information on partitioned ...
    Posted to Davide Mauri (Weblog) by manowar on January 7, 2010
Privacy Statement