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 Everything about SQL Server temporary tables: local (#temp), global (##temp), table variables, and when to use each. Includes creation syntax,... 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
SQL Server Greg Larsen in SQL Server Learn T-SQL: a free guidebook to SQL Server programming Free from Redgate: a beginner's guide to T-SQL covering SELECT statements, joins, GROUP BY, and more. Download the PDF and... 20 July 2020 2 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 Stale SQL Server Views: Detecting and Fixing Views After Table Changes SQL Server views can silently return wrong columns after underlying tables are altered. Learn to detect stale views with sp_refreshview,... 31 March 2020 24 min read
T-SQL Programming Greg Larsen in T-SQL Programming SQL Server Batch Mode on Rowstore: Reduce CPU on Analytic Queries SQL Server 2019 Batch Mode on Rowstore reduces CPU usage of large analytic aggregate queries by 20–30% without rewriting any... 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 Gaps and Islands in SQL Server: Efficient Window Function Solutions Advanced gaps and islands analysis in SQL Server using efficient window function patterns. Covers streak detection, PARTITION BY for multi-entity... 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
T-SQL Programming Kathi Kellenberger in T-SQL Programming PERCENTILE_CONT in SQL Server: Continuous Percentile and Interpolation Explained How the SQL Server PERCENTILE_CONT function computes continuous percentiles using interpolation, with a worked example from AdventureWorks, comparison with PERCENTILE_DISC,... 17 October 2019 11 min read
T-SQL Programming Joe Celko in T-SQL Programming SQL and Scope Understanding scoping rules is a basic skill for developers. In this article, Joe Celko gives a bit of the history... 07 October 2019 20 min read
T-SQL Programming Dennes Torres in T-SQL Programming SQL Server 2019 Graph Database and SHORTEST_PATH With SQL Server 2019 on the way, it’s time to begin learning about all the new features. In this article,... 11 September 2019 13 min read
