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.
AI_GENERATE_CHUNKS in SQL Server 2025: Splitting Long Text Into Pieces
AI_GENERATE_CHUNKS cuts one long piece of text into smaller pieces inside a query. This post tests the preview function on SQL Server 2025, shows what its columns hold and how overlap works, and explains how chunk size changes the number of pieces.
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.
SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Output Clause in Simple Examples – Day 14 of 35
The OUTPUT clause in simple examples: see exactly which rows your INSERT, UPDATE or DELETE changed, using the INSERTED and DELETED tables.
SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Ranking Functions – Advanced NTILE in Detail – Day 13 of 35
How the NTILE ranking function splits sorted rows into groups, or tiles, explained with a class ranking example from the Joes 2 Pros series.