T-SQL Crossword: 24 Clues, Answers Next Week

A T-SQL crossword with a real grid and 24 clues. Every answer is a word you have typed, or a word that has typed you. Answers next week, in the comments if you cannot wait.

The Sunday puzzle page was my favourite part of any magazine. Nobody has ever done one for this job, so here it is.

Print it and do it with a pencil, the way it’s meant to be done. Or screenshot it and argue with a colleague. Both count.

The T-SQL crossword grid, fifteen squares by fifteen, with twenty four numbered starting squares and the black squares filled in.

The grid

12
345
6
789
10
111213
14
15
16
17181920
2122
23
24

Numbers mark where a word starts. Black squares are black squares.

Across

  • 1. What the optimiser hands the engine (4)
  • 3. The kind of index access you get without a WHERE (4)
  • 7. Table with no clustered index and a forwarding problem (4)
  • 10. Code that runs whether you asked or not (7)
  • 11. The hint that reads a row twice and calls it speed (6)
  • 14. Lookup that ran 200,052 times (3)
  • 15. Two sessions, each waiting for the other, one chosen to die (8)
  • 17. A hope, until restored (6)
  • 21. The half of backup that people forget to test (7)
  • 23. What a session does when it is not working (4)
  • 24. Match built with a table in memory (4)

Down

  • 2. Nested join for small outer inputs (4)
  • 4. Row by row, and usually a mistake (6)
  • 5. Join that needs both inputs sorted (5)
  • 6. The good kind of index access (4)
  • 8. Empties a table by deallocating its pages, and it can still be rolled back (8)
  • 9. The only statement most people ever run (6)
  • 12. The command that finds corruption before your users do (7)
  • 13. Neither true nor false, and not equal to itself (4)
  • 16. Lightweight lock on a page in memory (5)
  • 18. Turns rows into columns (5)
  • 19. Operator with a memory grant and an attitude (4)
  • 20. Where sorts go when their memory runs out (6)
  • 22. The scouting report, and it can be stale (5)

Why a crossword

I have written the same explanations for twenty years. Clustered index, execution plan, deadlock, seek. The words go by so often that they stop landing.

A clue does something an explanation can’t. It hides the word and describes the shape of it, so you have to reach for the idea rather than the label. “Row by row, and usually the wrong choice” is four letters, and you know it before you can spell out why.

That is the whole reason this exists. Not to test anyone. To make two dozen familiar words feel unfamiliar for a minute, which is when you notice what you actually know about them.

Every answer in this T-SQL crossword is a word you have typed or read in a plan. Nothing here is trivia, and nothing needs a search. If a clue beats you, the answer is next week and the grid will still be here.

T-SQL crossword house rules

No prizes, because I’ve met you and you’d want the mug. The answers appear next week, and in the comments before that if enough people ask.

One clue refers to a number from a post I never published. That’s fine. The clue still works.

If you finish it in under ten minutes, you’ve spent too long in this profession. Take the afternoon off.

A crossword is not a test, it is a conversation with someone who knows the same words.

Published by Pinal Dave on SQLAuthority. More of my work at pinaldave.com.


Discover more from SQL Authority with Pinal Dave

Subscribe to get the latest posts sent to your email.

SQL Function, SQL Humor, SQL Scripts, SQL Training
Previous Post
How Many Pages Are in the Stack? Sunday Puzzle

Related Posts

Leave a Reply

Your email address will not be published. Required fields are marked *

Fill out this field
Fill out this field
Please enter a valid email address.