Index maintenance on modern storage needs query evidence, page density, and statistics checks before you choose a rebuild or lighter action.
SQLAuthority News – Birthday of SQL Authority Author
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.