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
puzzle

SQL SERVER – Solution Part 2 – A Quick Puzzle on SQL JOIN and NULL – SQL Brain Teaser

February 17, 2012
Pinal Dave
SQL Puzzle
SQL Joins, SQL NULL, SQL Scripts, SQL Server

Part 2 of the solution to my puzzle on SQL Join and NULL. Readers still email me answers every day, so here are more of the good ones they sent.

Read More
Gouache painting of document cards following a branching wooden track, with one queue blocked by a red barrier and another reaching an output drawer.

T-SQL Errors and Reactions in SQL Server: SQL in Sixty Seconds #002

February 15, 2012
Pinal Dave
SQL Video
SQL Error Messages, SQL in Sixty Seconds, SQL Scripts, SQL Transactions

T-SQL errors and reactions are the subject of this early SQL in Sixty Seconds episode with Rick Morelan. The tests here show which errors stop one statement, which stop the whole batch, and how XACT_ABORT, TRY CATCH and THROW change the reaction.

Read More
SQL SERVER - Solution - A Quick Puzzle on JOIN and NULL - SQL Brain Teaser

SQL SERVER – Solution – A Quick Puzzle on JOIN and NULL – SQL Brain Teaser

February 11, 2012
Pinal Dave
SQL Puzzle
SQL Scripts

The solution to my quick puzzle on JOIN and NULL. Many readers said the puzzle had an error; it did not, and here is the answer that works.

Read More
SQL SERVER - A Quick Puzzle on JOIN and NULL - SQL Brain Teaser

SQL SERVER – A Quick Puzzle on JOIN and NULL – SQL Brain Teaser

February 10, 2012
Pinal Dave
SQL Puzzle
SQL Scripts, SQL Server

A relaxing SQL Brain Teaser on INNER JOIN and NULL: set up a sample table, look at the result, and fill in the missing T-SQL that produces it.

Read More
Gouache painting of records coming together at a join

SQL SERVER – INNER JOIN Returning More Records than Exists in Table

February 9, 2012
Pinal Dave
SQL Puzzle
SQL Joins, SQL Scripts

Can an INNER JOIN returning more records than exist in a table be right? Jeff thought it was a bug. Our chat shows why it is possible and natural.

Read More
Gouache painting of a database character beside a stopwatch

Convert Subquery to CTE: SQL in Sixty Seconds #001

February 8, 2012
Pinal Dave
SQL Video
CTE, SQL in Sixty Seconds, SQL Scripts, SQL Sub Query

You can convert subquery to CTE syntax by naming the inner query and using that name in the outer query. The first SQL in Sixty Seconds episode shows the change. My tests on SQL Server 2025 show the result stays the same, and that a CTE used twice reads the table twice.

Read More
SQL SERVER - ERROR: FIX - Database diagram support objects cannot be installed

SQL SERVER – ERROR: FIX – Database diagram support objects cannot be installed

February 6, 2012
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Scripts, SQL Server

Database diagram support objects cannot be installed because this database does not have a valid owner. Here is the quick fix I used on a friend’s database.

Read More
Previous 1 … 208 209 210 211 212 213 214 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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