Choose SQL Server system views by the question they answer, distinguish catalog metadata from runtime counters, and understand reset boundaries.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
AND and OR: Parentheses Make Predicate Precedence Clear
AND and OR predicates need explicit grouping. Use a complete small truth table to expose which alternatives share a common requirement.
SQL SERVER – Correct Syntax for Stored Procedure SP
What is the correct syntax for stored procedure code? Anything between BEGIN and END is part of the procedure, and anything after GO is not, as my examples show.
SQL SERVER – 2005 – List All Stored Procedure in Database
Want to see all stored procedure in database at once? Run SELECT * FROM sys.procedures. This simple query works only with SQL Server 2005.
SQL SERVER – Rules of Third Normal Form and Normalization Advantage – 3NF
What is Third Normal Form and what is its advantage? I ask this in every interview I take. Here are the rules of 3NF and its cost in performance.
SQLite or SQL Server Express for a Small App
SQLite or SQL Server Express depends on write concurrency, deployment, backup, and the growth path your small application really needs.
Multiset Intersection: Keep the Matching Duplicate Occurrences
Multiset intersection keeps the duplicate count shared by both inputs rather than returning each common value once. I pair numbered occurrences to express that requirement. The result should contain the smaller count for each equivalent value.
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.