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 14 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 Hands-On with Columnstore Indexes: Part 4 Query Patterns All queries run fast against columnstore indexes, right? In this article, Edward Pollack demonstrates some query patterns that don’t perform... 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
Phil Factor Temporary Tables in SQL Server Temporary tables are used by every DB developer, but they're not likely to be too adventurous with their use, or... 01 August 2020 22 min read
Performance Edward Pollack in Performance Hands-On with Columnstore Indexes: Part 3 Maintenance and Additional Options In this article of this series, Edward Pollack demonstrates the maintenance of columnstore indexes. He also takes a look at... 21 July 2020 22 min read
T-SQL Programming Edward Pollack in T-SQL Programming Hands-On with Columnstore Indexes: Part 2 Best Practices and Guidelines In the second article of this series, Edward Pollack demonstrates some ways to design and populate a columnstore index to... 24 June 2020 20 min read
T-SQL Programming Uwe Ricken in T-SQL Programming Heaps in SQL Server: Part 2 Optimizing Reads In the second article of this series, Uwe Ricken discusses ways to affect the performance of queries involving heaps, including... 22 June 2020 18 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 Hands-On with Columnstore Indexes: Part 1 Architecture Microsoft introduced Columnstore with SQL Server 2012 and have improved the feature in every version since then. You may be... 21 May 2020 22 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 23 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 Beginner Guide to In-Memory Optimized Tables in SQL Server Microsoft added the In-Memory OLTP (aka memory optimized tables) feature to SQL Server 2014. Operations to this type of table... 14 February 2020 17 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 Introduction to Gaps and Islands Analysis T-SQL window functions simplify solving many complex queries. In this article, Edward Pollack demonstrates how the functions can be used... 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 What Does PERCENTILE_CONT Do? In this article, Kathi Kellenberger takes on a logic puzzle in trying to understand how the windowing function, PERCENTILE_CONT, works.... 17 October 2019 10 min read
