I presented two sessions at TechInsight 2010 in Kuala Lumpur, Malaysia, from June 29 to July 1, 2010. The best part of the trip was the people and their response.
SQL SERVER – Computed Column – PERSISTED and Storage
How a computed column is created and why PERSISTED and storage go together: persisted columns take more space. Plus links to the whole series.
SQL SERVER – FIX: ERROR: 8170 Insufficient result space to convert uniqueidentifier value to char
Error 8170 says there is insufficient result space to convert a uniqueidentifier value to char. The simple fix is to give the VARCHAR its full 36 characters.
Inclusive End Dates: Why BETWEEN Misses the Last Day
Inclusive end dates describe whole calendar days, while BETWEEN compares the exact supplied endpoints. A date endpoint becomes midnight when compared with timestamp rows. A guarded disposable fixture makes the boundary conditions explicit.
Spatial Data Types for Beginners
Spatial data types in SQL Server use geometry for planes and geography for Earth; points, polygons, and indexes start with valid coordinates.
SQL SERVER – Find Queries using Parallelism from Cached Plan
A script by Feodor Georgiev that finds queries using parallelism from the cached plan, along with their plans. Please avoid running it on a busy production server.
Stop Blaming the User: Let Constraints Catch Bad Data
Blaming the user is the oldest joke in IT. Here’s why it fails, and how NOT NULL, CHECK, UNIQUE and foreign keys stop bad data before it lands.