Use XML compression in SQL Server 2022 to reduce XML storage, inspect partition settings, and compare CPU costs on your own workload.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
bit Conversion: Nonzero Numbers Become One
bit conversion turns any nonzero number into one. Compare zero, negative values, NULL and TRUE/FALSE text before treating conversion as validation.
Recursive CTE Cycles: Detect Loops and Depth Boundaries
Recursive CTE cycles need evidence of the repeated relationship. Use a visited path and separate cycle flags from deliberate depth boundaries.
Interview Questions and Answers Complete List Download
The SQL Server 2008 Interview Questions and Answers Complete List in one place. A good interview leads to a good career if the candidate is willing to learn.
SQL SERVER – 2008 – Interview Questions and Answers Part 8
SQL Server 2008 Interview Questions and Answers Part 8 starts with Data Compression: how row compression and page compression work and save space.
SQL SERVER – 2008 – Interview Questions and Answers Part 7
SQL Server 2008 Interview Questions and Answers Part 7: how to rewrite sub-queries with joins or a CTE, what CLR is, and more answers with examples.
SQL SERVER – Interview Questions and Answers – Part 6
Part 6 of my SQL Server Interview questions and answers covers SQL Server 2008, starting with what the master, msdb, model, tempdb and resource databases do.
SQL Server slow? Let's fix it together in about four hours.
In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.
You keep every script, and the know-how to fix it yourself next time.
Want your whole team to learn it?
My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.
Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.