Error 1807 says SQL Server could not obtain an exclusive lock on database ‘model’ during CREATE DATABASE. The fix that worked for me takes seconds.
SQLAuthority News – 1200th Post – An Important Milestone
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.
DATETIME2FROMPARTS: Match Fractions to Precision
DATETIME2FROMPARTS constructs a complete typed timestamp. Match fraction units to precision and preserve valid calendar components.