Posts

Check Memory Pressure in 45 Seconds. The "45 Seconds DBA Series" – What Real DBAs Check First | Part 4 🥇

Image
Before we dive into today's topic, if you missed my previous post you can take a look at   Check CPU Pressure in 45 Seconds . 👉 If you found this deep-dive helpful, feel free to check out the ads—your support helps me keep creating high-quality SQL Server content for the community. Check Memory Pressure in 45 Seconds. The "45 Seconds DBA Series" – What Real DBAs Check First | Part 4 🥇 In this post, I’ll show you my 4-step diagnostic playbook to identify deadly SQL Server memory pressure in under 45 seconds. Stop guessing and start pinpointing exactly what is starving your buffer pool before performance grinds to a halt! TL;DR ✔️ OS Level: Check available physical memory—external pressure is dangerous 🛠️ ✔️ PLE (Page Life Expectancy): High is good, but sudden drops mean memory churn 📉 ✔️ Memory Grants: Long waits and huge grants are pure concurrency killers ⏳ ✔️ Memory Clerks: Find exactly which cache ...
Post a Comment
Read more

Check CPU Pressure in 45 Seconds. The "45 Seconds DBA Series" – What Real DBAs Check First | Part 3 🥇

Image
Before we dive into today's topic, if you missed my previous post you can take a look at Check Tempdb Health In 45 Seconds: Part 2 of the 45 Seconds DBA Series . 👉 If you found this deep-dive helpful, feel free to check out the ads—your support helps me keep creating high-quality SQL Server content for the community.
Post a Comment
Read more

Why SQL Server Starts Spilling to TempDB. The "45 Seconds DBA Series" – What Real DBAs Check First | Part 2 🥇

Image
Before we dive into today's topic, if you missed my previous post you can take a look at Check TempDB Health in 45 Seconds . 👉 If you found this deep-dive helpful, feel free to check out the ads—your support helps me keep creating high-quality SQL Server content for the community.
Post a Comment
Read more

Check TempDB Health in 45 Seconds. The "45 Seconds DBA Series" – What Real DBAs Check First | Part 1 🥇

Image
Before we dive into today's topic, if you missed my previous post you can take a look at SQL Server 2025 CU4: Are Your Queries Lying to You? The Hidden Full-Text Search Trap (Test Day 5) 👉 If you found this deep-dive helpful, feel free to check out the ads—your support helps me keep creating high-quality SQL Server content for the community.
Post a Comment
Read more

SQL Server 2025 CU4: Are Your Queries Lying to You? The Hidden Full-Text Search Trap (Test Day 5)

Image
Before we dive into today's topic, if you missed my previous post you can take a look at SQL Server 2025 CU4: Full-Text Search Strikes Again! Deep Troubleshooting. Test Day 4 . 👉 If you found this deep-dive helpful, feel free to check out the ads—your support helps me keep creating high-quality SQL Server content for the community. 💣 SQL Server 2025 CU4: Are Your Queries Lying to You? The Hidden Full-Text Search Trap (Test Day 5) ⚡ The Hook In this post, I’ll show you how SQL Server can return wrong results without throwing any error . If you rely on Full-Text Search , this can silently corrupt your logic and your business decisions. ⚡ TL;DR ✔️ Full-Text Search can return incomplete or incorrect results without errors 💣 ✔️ Language (LCID) mismatch breaks stemming silently ⚠️ ✔️ Parser output may differ from actual query results 🧪 ✔️ Always validate configuration, not just query execution ✔️ 🧠 Intro Hi SQL SERVER Guys, Today fast and focused post ! We a...
Post a Comment
Read more

SQL Server 2025 CU4: Full-Text Search Strikes Again! Deep Troubleshooting. Test Day 4

Image
Before we dive into today's topic, if you missed my previous post you can take a look at SQL Server 2025 CU4: The IStemmer Bug Fix – Did Microsoft Solve the FTS Crash or not? (Test Day 3) . 👉 If you found this deep-dive helpful, feel free to check out the ads—your support helps me keep creating high-quality SQL Server content for the community. SQL Server 2025 CU4: Full-Text Search Strikes Again! Deep Troubleshooting. Test Day 4 In this post, I’ll show you why a seemingly simple Full-Text patch for legacy documents can act as a "ghost bug". We will dive deep into troubleshooting fdhost.exe crashes to understand when SQL Server resilience actually hides a successful fix! TL;DR ✔️ KB 5008479 fixes an issue where indexing legacy Word 6.0 documents crashes the filter daemon 🛠️ ✔️ Proper service permissions and valid NOT NULL single-column PKs are mandatory for Full-Text ingestion 📦 ✔️ Modern libraries like offfilt02.dll provide resilience by catchin...
Post a Comment
Read more

SQL Server 2025 CU4: The IStemmer Bug Fix – Did Microsoft Solve the FTS Crash or not? (Test Day 3)

Image
Before we dive into today's topic, if you missed my previous post you can take a look at Understand stemming in SQL Server to become a better DBA . 👉 If you found this deep-dive helpful, feel free to check out the ads—your support helps me keep creating high-quality SQL Server content for the community, 20.04.2026 SQL Server 2025 CU4: Did Microsoft Finally Solve the FTS Crash? Test Day 3 In this post, I’ll reveal why your Full-Text Search queries might unexpectedly crash when using specific languages, and how SQL Server 2025 CU4 finally fixes the IStemmer bug. Stop letting undocumented language issues break your production code! TL;DR ✔️ KB 5071334 fixes Full-Text Search failures for version 2 languages missing an IStemmer 🛠️ ✔️ The bug caused hard errors when using FREETEXT or FORMSOF(INFLECTIONAL...) 💣 ✔️ You no longer need clunky workarounds for unsupported linguistic stems 🚀 ✔️ We provide the exact T-SQL to test and validate this fix in your environme...
Post a Comment
Read more

Understand stemming in SQL Server to become a better DBA

Image
Before we dive into today's topic, if you missed my previous post you can take a look at SQL Server 2025 CU4: Does JSON_CONTAINS Break Your Queries? Test Day 2 . 👉 If you found this deep-dive helpful, feel free to check out the ads—your support helps me keep creating high-quality SQL Server content for the community. 19.04.2026 Understand stemming in SQL Server to become a better DBA In this sunday post, I’ll show you how leveraging SQL Server's stemming capabilities can drastically improve your full-text search accuracy and reduce complex query overhead. Stop writing endless OR clauses and start letting the engine do the heavy lifting for you! TL;DR ✔️ Stemming reduces words to their root form to find all grammatical variations ✔️ FORMSOF(INFLECTIONAL, ...) eliminates the need for massive LIKE or OR chains ✔️ Full-Text Search language settings dictate whether stemming works 🌍 ✔️ You can query sys.fulltext_languages to check your instance's support...
Post a Comment
Read more

SQL Server 2025 CU4: Does JSON_CONTAINS Break Your Queries? Test Day 2

Image
Before we dive into today's topic, if you missed my previous post:    SQL Server 2025 CU3 vs CU4: Has Microsoft Really Fixed the SESSION_CONTEXT Issue? Test Day 1   .  👉  If you found this deep-dive helpful, feel free to check out the ads—your support helps me keep creating high-quality SQL Server content for the community. SQL Server 2025 CU4: Does JSON_CONTAINS Break Your Queries? Test Day 2 In this post, I’ll show you why a seemingly minor fix to JSON_CONTAINS in SQL Server 2025 CU4 might suddenly break your production workloads. Don't let silent logic errors ruin your uptime. Here is how to test and bulletproof your code! TL;DR ✔️ KB 5029490 limits the JSON_CONTAINS comparison mode strictly to 0 or 1 🛠️ ✔️ Mode 0 enforces an Exact Match, while Mode 1 allows Pattern Matching 🧩 ✔️ Parameterized queries face the highest risk of breaking changes upon upgrading to CU4 ⚠️ Hi SQL SERVER Guys, We all know how important it is to make every...
Post a Comment
Read more