My 1200th post, on the last day of 2009, looks back at a wonderful year and lists my top 7 community and personal events in the order they happened.
SQL SERVER – Fix Error 1949, Level 16: Cannot create index on view. The function yields nondeterministic results
Fix Error 1949: cannot create index on view because a function yields nondeterministic results. A training attendee hit it; removing that function solved it.
SQL SERVER – Get Date of All Weekdays or Weekends of the Year
Tejas Shah’s easy script to list the date of all weekdays or weekends of a year with a recursive CTE, first written to find every Sunday of 2010.
SQL SERVER – Difference Temp Table and Table Variable – Effect of Transaction
Temp table versus table variable, part two: a transaction rollback undoes changes to a temp table, but a table variable keeps its values.
Which Features You Lose When You Drop an Edition
Review SQL Server edition features before moving down an edition, check persisted dependencies, and test maintenance and availability behavior.
SQL SERVER – Whitepaper SQL Server 2008 Full-Text Search: Internals and Enhancements
A Microsoft white paper on SQL Server 2008 Full-Text Search internals and enhancements, including the new Full-Text Engine built into the database.
SQL SERVER – CDC and TRUNCATE – Cannot truncate table because it is published for replication or enabled for Change Data Capture
Does CDC capture a TRUNCATE? No. On a table enabled for Change Data Capture you get Msg 4711: Cannot truncate table. I recreate the error step by step.