A database for multiple customers can share tables, split schemas, or split databases; the choice balances isolation and operating cost.
SQL SERVER – Find Table Row Count Without Using T-SQL and Without Opening Table
An interview question: how do you find a table row count without using T-SQL or opening the table? SSMS table properties show it on the Storage page.
The Blocked Process Report
The blocked process report shows the waiting session and blocker after a configured threshold, with Extended Events capturing the XML for review.
SQL SERVER – Interview Questions – Difficult SQL Puzzle
Today at my organization, we had nearly 30 interviews scheduled of DBA and .NET developers. Let us see a difficult SQL puzzle.
TIMEFROMPARTS: Fraction Values Follow the Precision
TIMEFROMPARTS builds a time from separate components. The same fractions argument means milliseconds at precision three and much smaller units at precision seven.
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.