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 Paul White: Page Free Space (Weblog) by Paul White on September 11, 2012
  • Connect Digest : 2011-09-22

    Where is SYSDATE()? I've talked about this one before, but due to a recent conversation about building a datetime value from separate date/time columns or variables, it may be worth bringing up again. When SQL Server 2008 introduced several new date/time types, they also added new built-in functions, like SYSDATETIME() and SYSDATETIMEOFFSET(). ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on September 22, 2011
  • 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
  • Connect Digest : 2009-11-25

    Can we improve on CHECKSUM()? Mike C# is not happy with the reliability of CHECKSUM() and asks for a better function that has less (or no) chance of collisions.#513376 : A Better Collision-Free Hash Function for Comparing Rows of DataService termination and fatal exceptions are bad, m'kay? Victor Lobanov found an easy way to crash SQL Server, ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on November 25, 2009
  • Connect digest : 2009-06-20

    Here are the Connect items I'd like to draw your attention to this week.  I have abandoned the idea of trying to keep track of vote counts and overall rating.  Being lazy might be a small part of it, but it is mostly because I just don't think it makes sense to assume that my postings are all that influence Connect behavior.  I know ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on June 20, 2009
  • Validating What is Stored in a Partition/Filegroup

    How do you validate what is stored in a specific partition and the filegroup the partition resides on?  I have found this handy when designing a partition strategy and to double check it is behaving as I expect and my data is stored correctly for the requirements.  It also can help if you document as part of your disaster recovery ...
    Posted to Sarah Henwood (Weblog) by sarahhen on July 23, 2007
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement