Here is my introduction to Service Broker and sample script: messaging and queuing between instances, conversations and dialogs in SQL Server 2005.
SQL SERVER – Plan Caching and Schema Change – An Interesting Observation
What counts as a schema change for plan caching? More than table structure: adding or dropping an index also qualifies, per Greg Low’s white paper.
geometry STDimension: Count Dimensions, Not Points
geometry STDimension describes dimensionality rather than the number of coordinates. A mixed collection reports its highest-dimensional element.
SQL SERVER – Find Gaps in The Sequence
How do you find gaps in a Sequence of numbers? A reader asked, and two experts, Brian and Tejas, replied with good scripts. Here are both solutions.
SQL SERVER – FIX – ERROR : Cannot drop the database because it is being used for replication. (Microsoft SQL Server, Error: 3724)
Error 3724 stops you from dropping a database once used for replication. My simple fix: back up an empty database with the same name and force a restore.
SQL SERVER – Mirrored Backup and Restore and Split File Backup – Introduction
Backup and Restore lessons from my consulting work: conventional backups, split file backups, mirrored backups and the FORMAT clause, each with an example.
REGEXP_MATCHES: Read Matches and Capture Groups
REGEXP_MATCHES returns full matches and captured groups. Read group values and positions, preserve duplicate letters, and check a no-match input.