A view in SQL Server is a saved query, not a saved copy. Nothing is stored, the text is run every time, and that single fact explains what a view is good for and why it never makes anything faster.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
Cleaning Up Ownership Before Dropping a Departed User
DROP USER fails when the user still owns a schema, a role or a table. Here is how to find those owners and hand them over safely.
Finding Deprecated Features Before They Bite
Find deprecated features with SQL Server counters, event metadata, and code searches, then separate future risk from features already removed.
Indexing Basics Course: Learning SQL Server Performance
Vinod Kumar and I released an indexing basics course in 2012. This post keeps the original outline and cartoon, and adds tests on SQL Server 2025 for four of its practical topics: column order, functions on indexed columns, filtered indexes and disabled indexes.
T-SQL Errors and Reactions Demo: SQL in Sixty Seconds #005
This T-SQL errors and reactions demo follows episode #002 with queries you can run. It shows what a CATCH block can read, how severity is stored, how to log a failure and keep going, and why THROW keeps the original error while RAISERROR replaces it.
Optimized Plan Forcing: Cutting Compile Time in SQL Server 2022
Check optimized plan forcing in SQL Server 2022 through scoped configuration and Query Store replay flags, then compare compile duration.
Why Staging Tables Earn Their Keep
Use staging tables to preserve raw input, validate changes, separate extraction from publication, and make failed loads easier to diagnose and replay.
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.