Using the Same Column Twice in a SQL UPDATE Statement
An application developer came to me with this question recently: “Can I use the same column twice in a SQL UPDATE statement?” Yes and no. It depends on what you…
Read More 
T-SQL Tuesday #96: Three Pivot Points
T-SQL Tuesday is a monthly blog series made up of community contributions. This month’s topic is “Folks Who Have Made a Difference”, by Ewald Cress. This month’s T-SQL Tuesday is an…
Read More 
Why You Can’t Use ROW_NUMBER() In Your WHERE Clause
Here’s a common coding scenario for SQL Server developers: “I want to see the oldest amount due for each account, along with the account number and due date, ordered by…
Read More 
Three Magic Letters to Make Your DBA Like You More
Database Administrators are a finicky bunch. They fret over fine details and fuss over imperfections in our code. It’s not that they obsess over these things because they enjoy it.…
Read More 
Stop Using PRINT to Track Query Progress
For years, I relied on using PRINT in my T-SQL to give me updates on my script’s progress in SQL Server Management Studio. After each major statement, I’d throw in…
Read More