SQL Server TIME Data Type: Range, Precision and Usage
SQL Server's TIME data type stores time of day from 00:00:00.0000000 to 23:59:59.9999999 with scale 0-7. Range, byte sizes and T-SQL examples.
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.
SQL Server's TIME data type stores time of day from 00:00:00.0000000 to 23:59:59.9999999 with scale 0-7. Range, byte sizes and T-SQL examples.
Scalar UDFs can force a serial plan and ignore MAXDOP. Learn to read the plan node, benchmark the rewrite to inline or TVF, and check compatibility level.
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.