Predicate Execution Order on Mixed Data Type Columns
Watch this week’s episode on YouTube. SQL Server...
2019-05-22
Database Performance
2019-05-22
Distinct Rows, And The Columns You Choose
Footnote I have two queries. They return the same number of rows. The only difference is one column in the…
2019-05-20
Should Optimistic Be The Default Isolation Level?
Two Words Alright, I’ve lied to you already. There are way more than two words involved, here. I recently had…
2019-05-15
Queries with RECOMPILE and Query Store
Last week in our IEPTO2 class I was asked about queries with RECOMPILE and Query Store. Specifically: Do queries that have the OPTION (RECOMIPLE) hint go into Query...
2019-05-14
SQL Server 2017: here a NUMA, there a NUMA...
The first unexpected behavior is one that may already be familiar to many. [Max server memory] is not as often a maximum for SQL Server [total] memory as it...
2019-05-14
SQL SERVER – Get Last Known Actual Execution Plan for a Previously Cached Query Plan
This feature works with SQL Server 2019 and onwards. If you are using an earlier version of SQL Server this feature will not work and will give you an...
2019-05-11
How to load test a SQL database
How do you know whether a database code change is going to be great, okay or awful? If you want to test a new version of SQL Server how...
The...
2019-05-08
The Only Thing Worse Than Optional Parameters…
Kitchen Stink A lot has been written about “kitchen sink” queries. A couple of my favorites are by Aaron Bertrand…
2019-05-07
Introduction to Wait Statistics
Paul Randal provides a detailed introduction to troubleshooting SQL Server workload performance using wait statistics.
The post Introduction to Wait Statistics appeared first on SQLPerformance.com.
2019-05-07
Blogs
DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
Forums
Training the next generation
Comments posted to this topic are about the item Training the next generation
Reusing Customer Specific Order Filtering Logic with CROSS APPLY and an Inline TVF (Part 4)
Comments posted to this topic are about the item Reusing Customer Specific Order Filtering...
PostgreSQL psql Meta Commands: Databases
Comments posted to this topic are about the item PostgreSQL psql Meta Commands: Databases
Question of the Day
PostgreSQL psql Meta Commands: Databases
Which of the following meta commands (sometimes called backslash or slash commands) within psql will provide you with information about the databases on the cluster?
See possible answers