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.
SQL SERVER – Validate an XML Document in TSQL using XSD by Jacob Sebastian
Jacob Sebastian shows how to validate an XML Document in T-SQL with XSD. An XML Schema Collection checks the structure and values of an XML column or variable.
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.
What Is Installed? Finding Every SQL Server Component
Finding every SQL Server component starts with the Setup discovery report, then checks services, engine versions, and separate client tools.