One query, three versions, and the one rule that explains all of them. The question sounds simple: “Show me all bookings that have not been invoiced yet — so no invoice that is already Exported or Printed.” A first attempt at this query…
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.…
I have a Leatherman Wave, use it a lot, it’s a kind of Swiss Knife. Let me introduce the ‘SQL Error Atlas’.As a SQL Server Consultant going onsite (but being offline because of security) I use my ‘SQL Error Atlas’…
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…
You just want go home, the sun is shining and you think about dinner.. Then there is an alert that the backup of the transaction log from a database on the primary is corrupt.. What to do next … What…
