A quick Monday puzzle: what happens when you REPLICATE over 8000 characters into a VARCHAR(MAX) variable? Guess the lengths before you run it.
SQL SERVER – Recover the Accidentally Renamed Table
There is no undo for an accidentally renamed table in SSMS, sadly. Here are a few things you can check to find clues about what the original name was.
SQL SERVER – Solution – 2 T-SQL Puzzles – Display Star and Shortest Code to Display 1
A recap of my two T-SQL puzzles, the star from CAST(634 AS VARCHAR(2)) and the shortest code to display 1, after 350+ replies from readers.
SQL SERVER – Understanding XML – Contest Win Joes 2 Pros Combo (USD 198) – Day 5 of 5
Day 5, the last day of our contest, is about understanding XML. Answer the quiz for a chance to win the Joes 2 Pros 5 volume kit worth USD 198.
SQL SERVER – Expanding Views – Contest Win Joes 2 Pros Combo (USD 198) – Day 4 of 5
The day 4 question is about expanding views in SQL Server. Read the hints, answer the quiz and you may win a Joes 2 Pros book combo worth USD 198.
SQL SERVER – Clustered Index and Primary Key – Contest Win Joes 2 Pros Combo (USD 198) – Day 3 of 5
The day 3 quiz is on the clustered index and primary key. Answer it through the contact form for a chance to win the Joes 2 Pros combo worth USD 198.
SQL SERVER – Identity Fields – Contest Win Joes 2 Pros Combo (USD 198) – Day 2 of 5
Day 2 of the contest brings a question on identity fields. Read the hints, send your answer and you could win a Joes 2 Pros kit worth USD 198.