A short T-SQL script that finds where your SQL Server Data File folder is on disk, using master.sys.master_files. Handy when you forget where the files live.
SQL SERVER – FIX: Error: 1807 Could not obtain exclusive lock on database ‘model’. Retry the operation later.
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.
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.
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.
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.