This month's discount Comprehensive Database Performance Health Check · Testimonials
SQLAuthority with Pinal Dave
Home
  • Consulting
    • Health Check
  • Free Videos
  • All Articles
    • AI
    • SQL Performance
    • SQL Tips and Tricks
    • Interview Questions and Answers
    • SQL Puzzle
    • SQL Video
    • SQLAuthority News
    • Personal
  • Books
  • Consulting
SQL SERVER - Interesting Interview Questions - Revisited

SQL SERVER – Interesting Interview Questions – Revisited

December 17, 2008
Pinal Dave
SQL Interview Questions and Answers
Best Practices, Software Development, SQL Scripts

Readers took my Interesting Interview Questions test seriously. See who got the correct answer, and why good T-SQL mattered more than the schema.

Read More
SQL Server query execution plan.

SQL SERVER – Find Collation of Database and Table Column Using T-SQL

December 16, 2008
Pinal Dave
SQL Tips and Tricks
Database, SQL Collation, SQL Scripts, SQL Server Management Studio

A quick tip to find the collation of database and table column in SQL Server with DATABASEPROPERTYEX and sys.columns, using AdventureWorks.

Read More
SQL SERVER - Interesting Interview Questions - Part 2 - Puzzle

SQL SERVER – Interesting Interview Questions – Part 2 – Puzzle

December 10, 2008
Pinal Dave
SQL Interview Questions and Answers
SQL Scripts

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.

Read More
puzzle

SQL SERVER – Interview Questions – Difficult SQL Puzzle

December 7, 2008
Pinal Dave
SQL Puzzle
Database, SQL Scripts, SQL Server

Today at my organization, we had nearly 30 interviews scheduled of DBA and .NET developers. Let us see a difficult SQL puzzle.

Read More
Two similar wooden tops, one upright and one leaning on its rim with an off-center tip.

Comparing Float Values: Why 0.1 + 0.2 Is Not 0.3 in SQL Server

December 5, 2008
Pinal Dave
SQL Tips and Tricks
Best Practices, Mathematics, SQL Datatype, SQL Scripts

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.

Read More
Two rows of even stitches and one plain thread line on cream fabric under a sewing machine.

TIMEFROMPARTS: Fraction Values Follow the Precision

December 4, 2008
Pinal Dave
SQL Tips and Tricks
SQL Datatype, SQL Function, SQL Scripts, SQL Server

TIMEFROMPARTS builds a time from separate components. The same fractions argument means milliseconds at precision three and much smaller units at precision seven.

Read More
A vineyard row with a sloping wire between two posts, a red bead high on the right and a blue bead low on the left.

ATAN: Understand the Principal Angle of a Ratio

December 1, 2008
Pinal Dave
SQL Tips and Tricks
SQL Datatype, SQL Function, SQL Scripts, SQL Server

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.

Read More
Previous 1 … 294 295 296 297 298 299 300 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com