TIMEFROMPARTS builds a time from separate components. The same fractions argument means milliseconds at precision three and much smaller units at precision seven.
SQL SERVER – Default Collation of SQL Server 2008
How to check or change the default collation while installing SQL Server 2008. The setup default for server installs is SQL_Latin1_General_CP1_CI_AS.
POWER: Why an Integer Base Changes Fractional Results
POWER uses the base type when returning a result. Cast before calculation when fractional results matter and inspect decimal precision and scale.
ATAN: Understand the Principal Angle of a Ratio
ATAN converts a tangent ratio into a principal angle. The sign and selected interval matter, and a ratio alone cannot recover every original directional quadrant.
Service Broker Queue: Diagnose a Disabled Receiver
A disabled Service Broker receiver needs diagnosis before recovery. Read queue flags alongside application evidence, distinguish state from cause and check receiving, enqueueing, activation and poison-message handling separately.
SQL Server – Switch Between Result Pan and Query Pan – SQL Shortcut
The F6 Shortcut moves focus between SSMS panes. I use it when switching between the query editor and results.
SSMS or VS Code for SQL Server Work
Choose SSMS or VS Code for SQL Server work by task: administration, plans, scripts, MSSQL extension features, and team workflow.