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…
Blocking and Locking is used by the database engine to make sure the data is reportedback to you correctly, and never use WITH(NOLOCK) queries in production.Why? there is a change you report values incorrectly (data moves between pages or there…
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…
