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
Gouache painting of a small cottage with its own garden gate, brass keys on the latch and a vermilion mailbox.

Starting a Blog: Own the Domain From Day One

May 21, 2013
Pinal Dave
Personal
Best Practices, Blogging, WordPress

Starting a blog takes an afternoon, but where it lives is the hardest choice to undo. This post compares hosted platforms with self-hosted WordPress, explains why your own domain keeps your links and readers safe, and lists what to set up first and what to skip.

Read More
Gouache painting of a tidy shop window beside a community board full of blank pinned notes, with one vermilion pin.

Blog vs Website: Which One Do You Actually Need?

May 20, 2013
Pinal Dave
Personal
Best Practices, Blogging, Professional Development

The blog vs website question comes down to how much your words change. This post explains who needs which, how to combine them on one address, what a blog costs in time, and why original writing still matters when AI tools answer questions.

Read More
Hands passing a tied bakery box with a window across a doorstep, the layered cake inside still neat.

Sharing Query Results From SSMS: Copy With Headers, Grids and CSV

May 19, 2013
Pinal Dave
SQL Tips and Tricks
CSV, SQL Server, SQL Server Management Studio, sqlcmd

Share SSMS results with copy with headers, text and file output, deliberate CSV quoting, and command-line exports for larger sets.

Read More
Dark chocolate squares in an even grid on marble, one wrapped in red

Date Boundaries With DATETRUNC and EOMONTH in SQL Server 2022

May 18, 2013
Pinal Dave
SQL Tips and Tricks
SQL DateTime, SQL Function, SQL Server, SQL Server 2022

Use DATETRUNC and EOMONTH for month, quarter, and week boundaries in SQL Server 2022, including index-friendly half-open filters.

Read More
SQL Server query window.

SQL SERVER – Solution to Puzzle – REPLICATE over 8000 Characters

May 17, 2013
Pinal Dave
SQL Puzzle
SQL Function

Here is the answer to my puzzle on REPLICATE over 8000 characters, with a quick recap of the script and why the lengths come out the way they do.

Read More
Several mortar and pestle sets divide one herb batch beside a crowded single mortar

Page View Counters: Avoiding Hot Row Contention on Busy Rows

May 16, 2013
Pinal Dave
SQL Tips and Tricks
SQL Counter, SQL Lock, SQL Server

One counter row means every visitor waits in line. See how buckets spread the locks, and why rows on one page can still crowd each other.

Read More
A shuttlecock resting exactly on a court's boundary line, two rackets lying still on either side of the net.

Three-Valued Logic: TRUE, FALSE and UNKNOWN in a WHERE Clause

May 15, 2013
Pinal Dave
SQL Tips and Tricks
SQL NULL, SQL Operator, SQL Server, SQL Server 2022, SQL Sub Query

Understand three-valued logic in WHERE and CHECK, avoid NULL-poisoned NOT IN, and use SQL Server 2022 null-safe comparisons.

Read More
SQL SERVER - How to use xp_sscanf in Real World Scenario?

SQL SERVER – How to use xp_sscanf in Real World Scenario?

May 14, 2013
Pinal Dave
SQL Puzzle
SQL Scripts

I came across the extended stored procedure xp_sscanf and could not find a real world use for it. Here is how it works. Can you tell me where to use it?

Read More
SQL Server query result window.

SQL SERVER – Puzzle and Answer – REPLICATE over 8000 Characters

May 13, 2013
Pinal Dave
SQL Puzzle
SQL Function

A quick Monday puzzle: what happens when you REPLICATE over 8000 characters into a VARCHAR(MAX) variable? Guess the lengths before you run it.

Read More
Gouache painting of a harbor anchor chain broken in two by a missing link, with the lone link painted red

CONCAT_NULL_YIELDS_NULL and CONCAT: How NULL Behaves in Strings

May 12, 2013
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL NULL, SQL Scripts, SQL Server

The CONCAT_NULL_YIELDS_NULL setting decides whether a string plus NULL returns NULL. The CONCAT function never looks at it and treats NULL as an empty string. This post tests both on a customer table, shows the errors the OFF setting causes, and gives safe patterns for names and numbers.

Read More
Previous 1 … 340 341 342 343 344 345 346 … 593 Next
  • Books
  • Testimonials
  • Privacy Policy

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