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

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.

New
Performance & Internals
16/11/2026

Scalar Functions Execution Plan: Why SQL Goes Serial

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.

SQL blogcasts

Practical SQL Server notes and troubleshooting for DBAs and developers.

© 2026 SQL blogcasts

Topics

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

Latest notes

  • SQL Server TIME Data Type: Range, Precision and Usage
  • Scalar Functions Execution Plan: Why SQL Goes Serial
  • Word Hitcount Full-Text SQL: Count Occurrences
  • Script Data from SSMS: Generate INSERT Scripts with the Wizard

About

  • About the editors
  • Privacy policy
  • Terms of use