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
Four pale ceramic bowls in two pairs, three empty and the front-right bowl filled with blue pebbles.

IS DISTINCT FROM: Compare Nullable Values Without Sentinel Values

March 17, 2011
Pinal Dave
SQL Tips and Tricks
SQL NULL, SQL Scripts, SQL Server, SQL Server 2022

IS DISTINCT FROM compares nullable values without inventing a sentinel. Test two NULLs, one NULL and changed values, then use the predicate to find transitions that ordinary equality can miss.

Read More
Twelve unmarked wooden blocks in a row with a separate red end block.

GTIN-13 Check Digits: Validate the Final Digit in a CHECK Constraint

March 16, 2011
Pinal Dave
SQL Tips and Tricks
SQL Constraint and Keys, SQL Scripts, SQL Server

A GTIN-13 check digit validates a weighted checksum, not product identity. Test complete ASCII input, leading zeros and the final digit in a CHECK constraint, then see why some digit swaps still pass.

Read More
Gouache painting: a triangular sheet of flatbread dough lies on a floured board with one hazelnut at each of its three corners

geometry STNumPoints: Closing Coordinates Count Again

March 10, 2011
Pinal Dave
SQL Tips and Tricks
SQL Datatype, SQL Function, SQL Scripts, SQL Server

geometry STNumPoints counts coordinates in the spatial description. A square ring contains its closing coordinate as well as its four distinct corners.

Read More
Difference between DISTINCT and ALL in SQL Server.

SQL SERVER – Difference between COUNT(DISTINCT) vs COUNT(ALL)

March 8, 2011
Pinal Dave
SQL Tips and Tricks
SQL Scripts

What is the difference between COUNT(DISTINCT) and COUNT(ALL)? A student asked me at a college session, and one quick script made the answer clear.

Read More
Gouache painting: on a music room shelf, one tambourine hangs beside a stacked trio of tambourines

geometry STGeometryType: Type Names Say More Than Dimension

March 7, 2011
Pinal Dave
SQL Tips and Tricks
Spatial Database, SQL Function, SQL Scripts, SQL Server

geometry STGeometryType identifies the represented shape type, which carries more information than its dimension. I compare single and multiple shapes in one small query. Equal dimensions do not mean that their structures are interchangeable.

Read More
Sqlcmd.exe window.

SQL SERVER – Running Multiple Batch Files Together in Parallel

March 6, 2011
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Utility

I needed SQL code running in parallel for a demo, so I used sqlcmd and start cmd.exe to run multiple batch files together. Can PowerShell do it better?

Read More
Gouache painting: a wooden staircase with a red banister climbing to a landing in a quiet hall

hierarchyid GetAncestor: Stop at the Root

March 5, 2011
Pinal Dave
SQL Tips and Tricks
SQL Datatype, SQL Function, SQL Scripts, SQL Server

hierarchyid GetAncestor returns a logical ancestor path. Its zero-distance result is the original node, while a request beyond the root returns NULL.

Read More
Previous 1 … 233 234 235 236 237 238 239 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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