Build a materialized path hierarchy in T-SQL, query descendants, calculate depth, and move a subtree without creating cycles.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – Techniques for Retrieving Random Rows
This post will explore various techniques to retrieve random rows in SQL Server and analyze their performance and randomness characteristics in depth.
SQL SERVER – Checking If a Column Exists in a Table
Let us see a script that will help check if a Column Exists in a Table. One of the common tasks that developers deal with when working on database-related projects
Unit of Measure Conversions: One Table for Kilograms, Pounds and Boxes
Adding kilograms, pounds and boxes gives a number that means nothing. Convert each product to one base unit and find the rows that cannot convert.
SQL SERVER – Scripts to Retrieve Column Names
Understanding how to retrieve column names from a table is one of the fundamental operations you should be familiar with.
SQL SERVER – Transaction Logs: The Good, The Bad, and The Ugly
Providing a comprehensive understanding of their role and potential issues. Let us learn about Transaction Logs: The Good, The Bad, and The Ugly.
Webinar – Mastering SQL Query Performance: A Deep Dive into Index Tuning and Analysis
The webinar topic is Mastering SQL Query Performance: A Deep Dive into Index Tuning and Analysis. I will be hosting this webinar.
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.