T-SQL Programming Shel Burkow in T-SQL Programming A data transformation problem in SQL and Scala: Dovetailing declarative solutions This article is an interesting approach to solving a data transformation problem in SQL and Scala. Shel Burkow uses a... 22 February 2021 11 min read
T-SQL Programming Uwe Ricken in T-SQL Programming Heaps in SQL Server: Part 4 PFS contention When inserting rows into a heap, SQL Server must sometimes update the PFS page which can PFS contention and affect... 05 January 2021 15 min read
T-SQL Programming Joe Celko in T-SQL Programming Normal Forms To prevent data change anomalies, a database should be normalized. Did you know that there are 10 normal forms? In... 20 November 2020 22 min read
T-SQL Programming Joe Obbish in T-SQL Programming Dynamic Data Unmasking The SQL Server 2016 dynamic data masking feature may seem like a great way to obfuscate data for downstream systems... 15 September 2020 12 min read
T-SQL Programming Edward Pollack in T-SQL Programming Query Patterns for Columnstore Indexes: Joins & Performance (Part 4) Optimize query patterns against columnstore indexes in SQL Server. Learn segment and rowgroup elimination, dimension table joins, performance pitfalls, and... 01 September 2020 21 min read
T-SQL Programming Uwe Ricken in T-SQL Programming Heaps in SQL Server: Part 3 Nonclustered Indexes Uwe Ricken continues his series on heaps. This time he demonstrates a common scenario where the query against a heap... 18 August 2020 8 min read
T-SQL Programming Phil Factor in T-SQL Programming SQL Server Temp Tables: Types, Syntax & Best Practices Complete guide to SQL Server temporary tables - local (#), global (##), table variables, and table-valued parameters. Includes syntax, performance... 01 August 2020 23 min read
Performance Edward Pollack in Performance Columnstore Index Maintenance: Rebuild, Reorganize & Options Guide to columnstore index maintenance in SQL Server. Covers rebuild vs reorganize, rowgroup management, nonclustered columnstore indexes, and memory-optimized columnstore... 21 July 2020 23 min read
T-SQL Programming Edward Pollack in T-SQL Programming Columnstore Index Best Practices: Data Order & Partitioning (Part 2) SQL Server columnstore index best practices: optimize data order for rowgroup elimination, use segment metadata, implement partitioning, and apply archive... 24 June 2020 20 min read
T-SQL Programming Uwe Ricken in T-SQL Programming Optimize Heap Table Reads in SQL Server (Part 2 of 4) Optimize read performance on SQL Server heap tables. Covers advanced scanning, predicate pushdown, allocation order scans, partitioning, and compression techniques.… 22 June 2020 19 min read
T-SQL Programming Uwe Ricken in T-SQL Programming Heaps in SQL Server: Part 1 The Basics Most advice you see online about heaps is to avoid them. In this article, Uwe Ricken describes the basics of... 21 May 2020 9 min read
T-SQL Programming Edward Pollack in T-SQL Programming Columnstore Index Architecture in SQL Server (Part 1 of 4) Deep dive into columnstore index architecture in SQL Server. Learn how rowgroups, segments, the deltastore, and compression work with hands-on... 21 May 2020 23 min read
T-SQL Programming Edward Pollack in T-SQL Programming Tracking Underlying Object Changes in Views Views in SQL Server are used to simplify writing queries and managing security, but’s it’s easy for views to eventually... 31 March 2020 24 min read
T-SQL Programming Greg Larsen in T-SQL Programming Reduce CPU of Large Analytic Queries Without Changing Code Microsoft introduced several features called Intelligent Query Processing for SQL Server in 2017 and 2019 that can improve performance without... 25 March 2020 19 min read
Roy Ernest Introduction to SQL Server Spatial Data Many applications require the handling of geospatial data. Roy and Surenda take you through the basics of SQL Server spatial... 18 March 2020 22 min read
T-SQL Programming Monica Rathbun in T-SQL Programming SQL Server Memory-Optimized Tables: Beginner’s Guide Learn how memory-optimized tables work in SQL Server - In-Memory OLTP architecture, creating durable and schema-only tables, natively compiled stored... 14 February 2020 18 min read
T-SQL Programming Edward Pollack in T-SQL Programming Efficient Solutions to Gaps and Islands Challenges Window functions are useful for solving many SQL queries. In this article, Ed Pollack demonstrates how they can be used... 21 January 2020 32 min read
T-SQL Programming Edward Pollack in T-SQL Programming Gaps and Islands in SQL: Techniques & Examples Master gaps and islands analysis in SQL Server with practical T-SQL examples. Learn to identify consecutive sequences, find missing values,... 02 January 2020 19 min read
T-SQL Programming Joe Celko in T-SQL Programming Do You Have REFERENCES? The logic for referential integrity can be implemented in application code, but to make sure that it is enforced, include... 03 December 2019 13 min read
T-SQL Programming Joe Celko in T-SQL Programming Understanding Auctions We participate in auctions all the time even when we don’t realize it. In this article, Joe Celko discusses the... 29 October 2019 13 min read
