My notes from TechDays 2009 at Infosys, Bangalore on Nov 16-17: the largest Microsoft tech event at Infosys, with about 2,500 attendees in person and online.
SQL SERVER – 2008 Star Join Query Optimization
Star Join Query Optimization in SQL Server 2008 Enterprise Edition uses bitmap filtering to speed up data warehouse queries that join fact tables.
SQLAuthority News – Airline Review – Paramount, Kingfisher, Go Air, Indigo, Jet Airways, Indian Airlines, Spicejet
After 36 flights in two months, my airline review of Paramount, Kingfisher, Go Air, Indigo, Jet Airways, Indian Airlines and Spicejet, ranked by preference.
Validate an XML Document in T-SQL With an XSD Schema by Jacob Sebastian
To validate an XML document in SQL Server, store an XSD in a schema collection and type the variable or column with it. Jacob Sebastian’s lesson is kept, and I added tests on SQL Server 2025 that show the error number for each kind of bad document and what DOCUMENT and CONTENT accept.
Reading the Error Log With T-SQL
Reading the error log with T-SQL helps you search current and archived SQL Server messages, then set a useful log cycle schedule.
SQL SERVER – Size of Index Table for Each Index – Solution
Two reader solutions to my puzzle: queries that show the size of the index table for each index, accurate in nearly all of my tests.
DATEDIFF_BIG: Count Long Intervals Without int Overflow
DATEDIFF_BIG returns bigint boundary counts. Compare a long seconds interval, reversed dates and a tiny boundary crossing without overflowing int.