Today at my organization, we had nearly 30 interviews scheduled of DBA and .NET developers. Let us see a difficult SQL puzzle.
SQLAuthority News – 10 Motivational Quotes from Technologiest of the Past
Here are 10 motivational quotes from great technologists of the past, from Elbert Hubbard to Thomas Edison and Douglas Adams. Add your favorite too.
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.
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.