Today is the birthday of the SQL Authority Author, and my thought of the day is a simple one that I truly believe: family is everything.
SET_BIT: Return a Changed Value Without Updating Data
SET_BIT returns a value with one bit set or cleared. Compare the default one with explicit zero, and keep scalar calculation separate from updates.
SQL SERVER – Data Warehousing Interview Questions and Answers – Part 3
Data Warehousing Interview Questions and Answers Part 3 explains slowly changing dimensions: SCD1, SCD2, SCD3 and hybrid SCD, and what each one keeps.
SQL SERVER – Data Warehousing Interview Questions and Answers Part 2
Data Warehousing Interview Questions and Answers Part 2: normalization forms, fact and dimension table keys, data mining, view vs materialized view and ER diagrams.
SQL SERVER – Data Warehousing Interview Questions and Answers – Part 1
Part 1 of my Data Warehousing interview questions and answers, starting with the basics: what a data warehouse is and how it supports decision making.
Replacing a Cursor With a Set-Based Query
Replacing a cursor with one set-based update can simplify row processing; this worked example shows correctness checks and fair timing.
XQuery FLWOR: Filter and Rebuild a Small XML Result
XQuery FLWOR can iterate over source items and construct a different XML result. I use it to filter three products and reorder the survivors. The new elements deliberately differ from the source elements.