Use spatial indexes for geography distance searches, compare actual plans and reads, and inspect tessellation with built-in diagnostics.
SQL SERVER – Computed Columns – Index and Performance
The last article in my series on computed columns looks at index and performance, with a summary of every earlier part on storage and PERSISTED columns.
Finding the Nearest Store With the geography Type
Find the nearest store with SQL Server geography, validate coordinate order, apply a distance radius, and inspect spatial index use.
SQL SERVER – Computed Column and Performance – Part 3
Part 3 of my series on computed column and performance shows how an index improves the performance of a computed column. Read the earlier parts first.
Heap Tables: When a Table Without a Clustered Index Hurts
Find heap tables, inspect forwarded records and empty-page behavior, and choose between a clustered index and a planned rebuild.
Keyset Paging: Continue After a Date and ID Cursor
Keyset paging continues after a saved ordering key instead of counting past an offset. A date and unique ID together keep equal-date rows in the sequence. A guarded disposable fixture makes the boundary conditions explicit.
SQL SERVER – Index Levels, Page Count, Record Count and DMV – sys.dm_db_index_physical_stats
How many pages does an index use, and how many B-Tree levels does it have? sys.dm_db_index_physical_stats shows index levels, page count and record count.