An easy introduction to CHECK Options on views: why an update through a view can make rows drop out of it, and how CHECK OPTION stops that.
SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Introduction to Views – Day 23 of 35
An introduction to views from Joes 2 Pros: the rules a query must follow before it can become a view, like giving every expression column a name.
SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – All about SQL Constraints – Day 22 of 35
All about SQL constraints, starting with check constraints: how to keep a column to sensible values, like no negative height on a medical form.
ANY and ALL: Comparing a Value to a Whole Subquery in T-SQL
One missing price is enough to make ALL return nothing while ANY returns rows. Here is how to see it, and how to ask the question more safely.
SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – All about SQL Statistics – Day 21 of 35
All about SQL statistics, starting with a real life example: just as we plan for winter from past seasons, SQL Server uses statistics to plan ahead.
SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Introduction to Page Split – Day 20 of 35
An easy introduction to page split: what happens when a new record belongs on a data page that is already full, following the clustered index order.
SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – The Clustered Index Simple Understanding – Day 19 of 35
Clustered index simple understanding: the clustered index is the physical order of your data, like mall stores ordered by unit number. A Joes 2 Pros tip.