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 emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
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.
SQL SERVER – Interesting Observation – Use of Index and Execution Plan
Three AdventureWorks examples show how the Query Optimizer picks an index, what happens when you force one, and how that changes the index and execution plan.
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.
SQL Server slow? Let's fix it together in about four hours.
In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.
You keep every script, and the know-how to fix it yourself next time.
Want your whole team to learn it?
My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.
Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.