Bevat..
How they work… “I have a transactions table (~10M rows) and a card_banlist table (~1M rows).I want every transaction that happened on a banned card after that card’s ban date.” Setup some objects. The query we are using. The Execution…
SQL Server 2025 ships three backup compression algorithms — MS_XPRESS, QAT_DEFLATE, and ZSTD — and none of them is universally best. I built a small Windows tool that runs all of them against a real database side by side, so…
On Youtube I saw a demo of “Brian Dill DuckDB 101” that was impressive, you can install DuckDB from here (An analytical SQL database management system – DuckDB), I am Dutch, it was developped at the CWI (DuckDB: a high-performance…
You want faster inserts right? You only see PAGELATCH_EX waitstats and have some cpu power? Can inserting data into a table using OPTIMIZE_FOR_SEQUENTIAL_KEY go faster? Why not find things out in this post — it has what most posts about…
Ola Hallengren does a great job with his IndexOptimize ( SQL Server Index and Statistics Maintenance ). . Discussion note from working through Jeff Moden’s ( (10) Jeff Moden | LinkedIn ) “Black Arts Index Maintenance #1.2 – GUIDs v.s.…
So you’re a good DBA (you automated everything), using Ola’s maintenance solution () and you think you have everything covered, you fill your day looking at Erik Darling’s ‘Darling Performance Monitoring’ service (). Than management asks you to do a…
When I was young (a long time ago, I sometimes call myself a DBA Dinosaur..) I developed in CPP a Windows Service (I read the MSDN magazine from Microsoft back then) to collect data from SQL Servers. And time went…
Parameter Sensitive Plan (PSP) optimization, new in SQL Server 2022 (compatibility level 160+)as part of Intelligent Query Processing. It’s Microsoft’s built-in fix for exactly the scenario you built: ParentId in Posts is wildly skewed (a handful of parent posts have…
All the functions. ASCII Animated Execution Plan: ASCII CHAR Animated Execution Plan: CHAR CHARINDEX Animated Execution Plan: CHARINDEX CONCAT Animated Execution Plan: CONCAT CONCAT_WS Animated Execution Plan: CONCAT_WS DIFFERENCE Animated Execution Plan: DIFFERENCE FORMATMESSAGE Animated Execution Plan: FORMATMESSAGE LEFT Animated…
Table variables versus #temp tables: Are you sure of that last one Mr. DBA? Checking the Properties the Estimates and Actuals are the same and even in Batch Mode. Ah.. Ronald you cheat because of the index.. nope I don’t.…
