A plan that reads a computed column shows two Compute Scalar operators, and the second one looks like a mistake. This post compares three tables in the plan text: an expression in the query, a computed column and a persisted computed column. It shows what each of the Compute Scalar operators defines and whether the extra operator costs anything.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL Puzzle – Solution to Strange Results – IN and IS NOT NULL –
Earlier I had published a blog post about a puzzle SQL Puzzle – IN and IS NOT NULL – Strange Results. Today we will see a solution to strange results puzzle.
Logging Free Space per Volume Into a Table Each Day
Log free space per volume from SQL Server volume metadata, keep one daily sample per mount point, and compare change with LAG.
Open Source Cloud: Final Post
Open source cloud, the final post: the whole ten part beginner series on one page, with key lessons and a simple guide on where to start.
The CXO Role in Implementing Open Source Cloud
The CXO role in implementing open source cloud: five simple steps from workload analysis to steady cost and performance reviews.
Checklist for the Best Open Source Cloud
A beginner friendly checklist for the best open source cloud: architecture, security, data rules, cost, skills, support and licenses.
What are the Different Layers of Open Source Cloud?
What are the different layers of open source cloud? A beginner friendly map from hardware to apps, with open source tools for each layer.
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.
Who We Are
Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 24 years of hands-on experience. He holds a Masters of Science degree and numerous database certifications.
Pinal has authored 19 books and 125 Pluralsight courses. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,800 database tech articles on his blog at https://blog.sqlauthority.com.
Pinal is also a CrossFit Level 1 Trainer (CF-L1) and CrossFit Level 2 Trainer (CF-L2).
Nupur Dave is a social media enthusiast and an independent consultant. She primarily focuses on the database domain, helping clients build short and long-term multi-channel campaigns to drive leads for their sales pipeline.
Shaivi Pinalkumar Dave is a book author and a women’s artistic gymnast.

