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.