A scheduled job has recorded scheduling metadata as well as its actual execution history. I check both before promising a next run.
SQL SERVER – Change Collation of Database Column – T-SQL Script
How to change collation of database column with ALTER TABLE ALTER COLUMN and COLLATE, then check it in sys.columns. A short test script shows each step.
SQL SERVER – Interesting Interview Questions – Revisited
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.