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.
Execution plans, indexes, the transaction log, SQL Agent jobs and wait stats: tested T-SQL for DBAs and developers, with the version it was run on.
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.
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.
Why DBA skills matter: what a DBA owns, how wait stats and CHECKDB prevent downtime and corruption, and how to build the skills employers notice.
Sort SQL Server rows by a dynamic column without dynamic SQL using CASE in ORDER BY, with execution plan notes, sargability risks and safer alternatives.
How to select specific columns from an EXEC stored procedure result in SQL Server using INSERT EXEC, OPENROWSET and WITH RESULT SETS.
How the SSIS Raw File Source reads .raw binary files, how Raw File Destination writes them, and how the raw format differs from flat files in SSIS.
LINQ to SQL does not expose full-text search; Contains() compiles to LIKE. Here is the ExecuteQuery + CONTAINS workaround with T-SQL and C#.
Database mirroring sends log records to the mirror with no documented compression switch. See which DMVs verify traffic and session state.
Use Event Notifications to capture blocked process reports in SQL Server. T-SQL setup for the threshold, Service Broker queue, and reading the XML.
A page split happens when an 8 KB data page has no room for a row. Learn how it fragments SQL Server indexes, how to detect it, and when to worry.