Dennes Torres in Blogs Query Performance Analysis in Lakehouses You may have already discovered the 4 special views the lakehouse has in the queryinsights schema to track query performance.... 09 April 2025 4 min read
Ben Johnston in Blogs Friendly Deletes in SQL Server One of the first things you learn when working with SQL Server, and other transactional based SQL systems, is that... 01 March 2024 24 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 14 min read
Jonathan Lewis Hacking Indexes Indexes are expensive to maintain so we want to get the greatest benefit we can from them and make sure... 03 October 2016 14 min read
Dwain Camps Using the T-SQL PERCENTILE Analytic Functions in SQL Server 2000, 2005 and 2008 Percentiles give meaning to measurements by telling you the percentage of the population being measured who get higher or lower... 18 May 2015 27 min read
Dennes Torres Optimizing Batch Process in SQL Server SQL Server batch processes are usually run from SQL Agent in background. They can take significant time and resources, especially... 08 May 2015 32 min read
Dennes Torres Identifying and Solving Index Scan Problems When you're developing database applications, it pays to check for index scans in the SQL Server query plan cache. Once... 10 March 2015 24 min read
.NET Jon Smith in .NET The Compromise Between Development Time and Performance in Data-Driven ASP.NET MVC As developers we always want to produce efficient code, but efficient in what - development time or overall performance? In... 03 March 2015 22 min read
Dino Esposito RWD, Mobile-first, JavaScript and Performance The easiest way to make a responsive web application perform well is to minimize requests and the amount of data... 28 February 2015 11 min read
Jonathan Watts The Promise – and the Pitfalls – of In-Memory OLTP When SQL Server 2014 was released, it included Hekaton, Microsoft's much talked about memory-optimized engine that brings In-Memory OLTP into... 04 February 2015 7 min read
Michael K Campbell The Importance of Caching Performance tuning and optimization definitely have their place in minimizing SQL Server Licensing costs - by helping keep CPU utilization... 04 February 2015 15 min read
Grant Fritchey Why Developers Need to Understand Execution Plans As a coder, the more you know about the business, the better code you're going to write. The more you... 12 January 2015 30 min read
Tony Davis Optimizing Transaction Log Throughput As a DBA, it is vital to manage transaction log growth explicitly, rather than let SQL Server auto-growth events "manage"... 08 May 2014 35 min read
Dwain Camps The Performance of Traversing a SQL Hierarchy Dwain Camps show that, depending on the size and characteristics of some hierarchical data, six different methods of traversal can... 28 April 2014 16 min read
Robert Sheldon 14 SQL Server Indexing Questions You Were Too Shy To Ask One of the first things one needs to understand well about SQL Server is indexes, but somehow many of the... 25 March 2014 22 min read
Dwain Camps High Performance Relational Division in SQL Server Relational division is used in SQL to select rows that conform to a number of different criteria. It is a... 24 March 2014 28 min read
Joshua Feierman Applying The Scientific Method to SQL Server Performance Tuning Database administrators tend to rely more on science than intuition, and may therefore seem exasperatingly cautious to other IT people.... 10 March 2014 14 min read
Fabiano Amorim Fixing Cache Bloat Problems With Guide Plans and Forced Parameterization Imagine it. You've been asked to fix a dire performance problem with a SQL Server database. You find a severe... 20 February 2014 10 min read
Gail Shaw SQL Server Deadlocks by Example When a SQL Server instance deadlocks, it can be anything from minor irritation to something far more severe. In this... 16 January 2014 54 min read
Alex Kuznetsov Lessons Learned from Six Years of Agile Database Development Alex Kuznetsov describes the agile principles, techniques and tools that allowed his development team to make frequent database refactoring a... 19 November 2013 26 min read
