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.
SQL SERVER – Geography Data Type – Calculating Distance Between Two Points on the Earth – Day 18 of 35
The Geography Data Type in SQL Server 2008 stores points and areas on the earth and has a built-in function to calculate the distance between two points.
SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Sparse Data and Space Used by Sparse Data – Day 17 of 35
A Joes 2 Pros tip on sparse data: when a column is almost always NULL, see how much space it still uses and how sparse columns can save it.
SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – System and Time Data Types – Day 16 of 35
A Joes 2 Pros tip on system and time data types: why date and time stamps matter so much, with a recap of the DateTime functions.
SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Data Row Space Usage and NULL Storage – Day 15 of 35
How much disk will a table need? Learn data row space usage and NULL storage so you can plan space for a table that gets 100,000 rows a day.