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.