Readers took my Interesting Interview Questions test seriously. See who got the correct answer, and why good T-SQL mattered more than the schema.
SQL SERVER – Find Collation of Database and Table Column Using T-SQL
A quick tip to find the collation of database and table column in SQL Server with DATABASEPROPERTYEX and sys.columns, using AdventureWorks.
SQL SERVER – Interesting Interview Questions – Part 2 – Puzzle
None of the 40 candidates I interviewed solved this simple puzzle, one of my interesting interview questions: find each person who has all the selected colors.
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.
Comparing Float Values: Why 0.1 + 0.2 Is Not 0.3 in SQL Server
Why does 0.1 + 0.2 miss 0.3 only when float is involved? A few tiny queries show the hidden digits, the drifting sum and two clean fixes.
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.
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.







