SQL blogcasts
  • Administration & Monitoring
  • Performance & Internals
  • About sqlblogcasts.com Editors
New
Performance & Internals
15/11/2026

Word Hitcount Full-Text SQL: Count Occurrences

Count word occurrences in SQL Server full-text columns using sys.dm_fts_index_keywords_by_document. Includes a query, worked example and performance notes.

New
Development & Integration
15/11/2026

Script Data from SSMS: Generate INSERT Scripts with the Wizard

Learn how to script data from SSMS: generate INSERTs for one table or a whole database, choose Types of data to script, and verify the output.

SQL blogcasts

Practical SQL Server notes and troubleshooting for DBAs and developers. Independent site, not affiliated with Microsoft.

© 2026 SQL blogcasts

Topics

  • Administration & Monitoring
  • Development & Integration
  • Performance & Internals

Latest notes

  • Word Hitcount Full-Text SQL: Count Occurrences
  • Script Data from SSMS: Generate INSERT Scripts with the Wizard
  • Why DBA Skills Matter: Wait Stats, CHECKDB and the Cost of Skipping Them
  • Dynamic ORDER BY Without Dynamic SQL in SQL Server

About

  • About the editors
  • Privacy policy
  • Terms of use