Browse by Tags

Tagged Content List
  • Blog Post: SQLCAT.Com - eBook Downloads

    As of September 1, 2013 we decided to remove SQLCAT.COM site and use MSDN as the primary vehicle to post new SQL Server content. This was done to minimize reader confusion and to streamline content publication. MSDN SQLCAT blogs already includes most SQLCAT.COM Content and will continue to be updated...
  • Blog Post: SQLCAT.com consolidated index of Whitepapers

    In an effort to migrate as much content as possible from SQLCAT.com to the MSDN SQL CAT site we have consolidated all of the Whitepapers published over the last few years. While all of the content actually exists on Technet and MSDN download sites, SQLCAT was a great resource to start looking. Hopefully...
  • Blog Post: New version of Partition Management Utility supports SQL2012, ColumnStore Indexes

    A new version of the Partition Management Utility for SQL Server is now available on Codeplex at http://sqlpartitionmgmt.codeplex.com/ . This is a tool that helps you create necessary staging tables and indexes and associated check constraints, to support partition-switch operations against existing...
  • Blog Post: Technical Reference Guides for Designing Mission-Critical Solutions using SQL Server are available

    The Technical Reference Guides for Designing Mission-Critical Solutions provide planning and architecture guidance for various mission-critical workloads deployed by users. These guides reflect the knowledge gained by the CAT team while working with customers on mission-critical deployments, many of...
  • Blog Post: Successfully execute an INSERT, UPDATE and DELETE against a Database Snapshot

    Author : Shaun Tinline-Jones Reviewers : Mike Ruthruff, Sanjay Mishra, Alexei Khalyako Not too long ago an ISV that developed solutions using SQL Server as the RDBMS, asked me how they could query a database as at a point in time. This was a relatively easy answer, thanks to the Database Snapshot...
  • Blog Post: “QUOTED_IDENTIFIER” causes Unexpected Query Plan for Persisted Computed Column query

    Author : Shaun Tinline-Jones Technical Reviewers : Thomas Kejser, Steve Howard, Jaime Alva Bravo, Kun Cheng, Jimmy May Note: Validation for this post was performed in the SQL CAT Customer Lab on an HP Proliant DL580 G7 , Intel Xeon Nehalem E7-4870 2.40 GHz 4 socket, 10 physical cores, 20 logical...
  • Blog Post: Enabling Partition Level Locking in SQL Server 2008

    Author: Thomas Kejser Reviewers: Juergen Thomas, Sanjay Mishra, Stuart Ozer, Lubor Kollar, Kevin Cox, Kun Cheng In this blog, we will provide additional details on a well-hidden feature in SQL Server 2008 – partition-level locking. But before we illustrate the feature, here’s a bit of background about...
  • Blog Post: Whitepaper About Star Join Optimizations

    When we talk to Data Warehouse customers – they often raise questions about the star joins improvements SQL Server 2008. Star join is a set of optimizations that provide some interesting performance gains in data warehouse workload. Instead of digging into details here on SQL CAT we want to draw your...
  • Blog Post: Assigning surrogate keys to early arriving facts using Integration Services

    In data warehouses, it is quite common that fact records arrive with a source system key that has not yet been loaded in the dimension tables. This phenomena is known as “late arriving dimensions” or “early arriving facts” in Kimball terminology. When you see a fact record that cannot be resolved...
Page 1 of 1 (9 items)