T-SQL Programming Greg Larsen in T-SQL Programming The basic T-SQL SELECT statement The SQL language is used across many relational database platforms. Greg Larsen explains the basics of the SELECT statement for... 22 February 2022 10 min read
T-SQL Programming Joe Celko in T-SQL Programming Quantifier predicates Predicates in SQL are often complex and difficult to understand. In this article, Joe Celko explains the logic behind a... 27 December 2021 11 min read
T-SQL Programming Joe Celko in T-SQL Programming BETWEEN the two of us BETWEEN can be used in a SQL WHERE clause to filter on a range. Joe Celko explains the history of... 15 November 2021 11 min read
T-SQL Programming Dennes Torres in T-SQL Programming Azure Synapse Serverless SQL: Querying Blob Storage with OPENROWSET – Filepath Filtering, Partitioning, Parquet vs CSV, and External Tables Performance-tuning SQL queries against Azure Blob Storage using Synapse Serverless SQL pool - filepath filtering with the filepath() function, partition-based... 21 October 2021 18 min read
CI/CD Sebastian Meine Liz Baron in CI/CD How to successfully deploy databases with external references Database objects often have references to external databases which makes continuous integration problematic. In this article Liz Baron and Sebastian... 29 September 2021 8 min read
T-SQL Programming Kathi Kellenberger in T-SQL Programming LAG in SQL Server: Performance vs Self-Join, CTE, APPLY, and Cursors Benchmarked Benchmarked comparison of the SQL Server LAG function against eight alternative techniques for including a column from a previous row:... 07 September 2021 13 min read
T-SQL Programming Joe Celko in T-SQL Programming Data, N-Tiles & Medians Joe Celko takes a look at how SQL Server can do some of the work for you such as calculating... 01 June 2021 14 min read
Editorials Kathi Kellenberger in Editorials What is an ad hoc query? Someone recently asked me which queries are ad hoc in SQL Server. An ad hoc query is a single query... 04 May 2021 4 min read
T-SQL Programming Shel Burkow in T-SQL Programming A data transformation problem in SQL and Scala: Dovetailing declarative solutions Part II In this article, Shel Burkow uses the SQL execution plan from the previous article to write a program in Scala.… 26 March 2021 15 min read
T-SQL Programming Joe Celko in T-SQL Programming What is interpolation? In this article, Joe Celko explains interpolation and covers a bit about the history and what we all did before... 11 March 2021 10 min read
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 SQL Server Heap PFS Contention: Diagnosing INSERT Bottlenecks (Part 4) PFS (Page Free Space) contention is a heap INSERT bottleneck in SQL Server that occurs during high-concurrency workloads. Learn how... 05 January 2021 15 min read
T-SQL Programming Joe Celko in T-SQL Programming Database Normal Forms Explained: 1NF, 2NF, 3NF, BCNF, 4NF, 5NF, and DKNF Complete reference to database Normal Forms - First Normal Form (1NF), Second Normal Form (2NF), Third Normal Form (3NF), Elementary... 20 November 2020 23 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 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
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
