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 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.