THE SQL Server Blog Spot on the Web

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

Browse by Tags

All Tags » performance » SQLCLR » parallel processing   (RSS)
  • Re-Inventing the Recursive CTE

    Working with hierarchies in SQL Server never fails to be absolutely fascinating. On the face of things they’re super-easy to model and seem to fit perfectly well: parent_key, child_key, self-referencing FK, and you’re done. But then you go to query the thing and there is a complete breakdown. Prior to SQL Server 2005 the product included zero ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on April 7, 2015
  • TechEd 2013: Demos for "Data, Faster: Microsoft SQL Server Performance Techniques with SQLCLR"

    Today at TechEd in New Orleans I delivered a breakout session entitled ''Data, Faster: Microsoft SQL Server Performance Techniques with SQLCLR.'' This session covered a number of techniques for using SQLCLR as a query tuning tool, especially for big, ugly, and heavily analytical queries. Thank you so much for all who attended and took the time ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on June 4, 2013
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement