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
Socks sorted into matched pairs on a quilt, a small pile of odd socks set apart, a hand holding up one sock.

Solving SQL Puzzles With Set-Based Thinking

March 20, 2008
Pinal Dave
SQL Puzzle
Ranking Functions, SQL Joins, SQL Scripts, SQL Server

Set-based thinking solves three SQL puzzles with grouping, anti-joins, and windows, then turns each solution into a repeatable query habit.

Read More
SQL SERVER - sp_HelpText for sp_HelpText - Puzzle

SQL SERVER – sp_HelpText for sp_HelpText – Puzzle

June 15, 2007
Pinal Dave
SQL Puzzle
SQL Scripts, SQL Stored Procedure

What happens when you run sp_HelpText on itself? It prints its own code. Plus tips for long lines, encrypted objects and searching object code.

Read More
Previous 1 … 19 20 21 22
  • Books
  • Testimonials
  • Privacy Policy

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