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 » SQL 2012 » SQLPASS TV   (RSS)
  • Skewed Data - Poor Cardinality Estimates... and Plans Gone Bad

    The session Skewed Data, Poor Cardinality Estimates, and Plans Gone Bad by Kimberly Tripp (@KimberlyLTripp) has been published on channel SQLPASS TV.  Abstract When data distribution is heavily skewed, cardinality estimation (how many rows the query optimizer expects each operator to process) can be wildly incorrect, resulting in ...
    Posted to Sergio Govoni (Weblog) by Sergio Govoni on February 14, 2014
  • Building Your T-SQL Tool Kit: Window Function Fundamentals

    The session Building Your T-SQL Tool Kit: Window Function Fundamentals by Christina E. Leo (@christinaleo) has been published on channel SQLPASS TV. Abstract Have you pulled a script to identify duplicates from a blog post but couldn't quite get it to work because you weren't sure what that ROW_NUMBER() function was doing? Maybe you ...
    Posted to Sergio Govoni (Weblog) by Sergio Govoni on January 21, 2014
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement