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 half-assembled wooden birdhouse on a workbench, with one vermilion peg in its top and the unused pieces lying beside it

Setup Error 1639: Invalid Command Line Argument in SQL Server

July 30, 2019
Pinal Dave
SQL Tips and Tricks
Command Line, SQL Error Messages, SQL Scripts, SQL Server, SQL Server Installation

Setup error 1639 stopped my SQL Server 2019 install with an invalid command line argument message. The real clue was in the log: a component from an earlier incomplete install was still there. Uninstalling it with msiexec fixed the problem.

Read More
Gouache painting of three potted plants on a stepped stand with a vermilion rosette on the tallest

Fewest Logical Reads: The Answer to the Delete Qualified Rows Puzzle

July 29, 2019
Pinal Dave
SQL Puzzle
SQL Delete, SQL Performance, SQL Scripts

The fewest logical reads for the multiple table delete puzzle come from reading each table as few times as the rules allow. A string of student IDs gets to 4 reads. A set based delete needs 5 and is the one to use. The starting script needed 19.

Read More
An opened pea pod lies beside its unwrapped peas

How to Remove Quotes of QUOTENAME? – Interview Question of the Week #235

July 28, 2019
Pinal Dave
SQL Interview Questions and Answers
SQL Function, SQL Scripts, SQL Server, SQL String

Question: How to Remove Quotes of QUOTENAME? I received based on my yesterday’s blog post SQL SERVER – QUOTENAME Function and Custom Quote Character.

Read More
Gouache painting of wooden frames in different shapes each holding a pebble, with the diamond frame in vermilion

QUOTENAME Function: Custom Quote Characters and Dynamic SQL

July 27, 2019
Pinal Dave
SQL Tips and Tricks
Dynamic SQL, SQL Function, SQL Scripts, SQL String

The QUOTENAME function turns a name into a safe identifier and doubles any closing delimiter inside it. Tested queries show which quote characters work, the 128 character limit and a dynamic SQL example. A short card lists the rules.

Read More
Gouache painting of four wheelbarrows of apples in an orchard with the fullest one in vermilion

Rows Read Per Thread: Four Ways to See Them in SQL Server

July 26, 2019
Pinal Dave
SQL Tips and Tricks
Execution Plan, Parallel, SQL DMV, SQL Scripts

Rows read per thread show whether a parallel query shares its work evenly. The post shows two plan based methods, a T-SQL query over the last actual plan, and a live DMV for running queries. A 500,000 row demo proves the threads add up to the table.

Read More
Gouache painting of a wall of cubbyholes each holding one boot and a vermilion boot waiting at an occupied cubby

Unique Index Performance: What a UNIQUE Index Saves

July 24, 2019
Pinal Dave
SQL Performance
Execution Plan, SQL Index, SQL Performance, SQL Scripts

Unique index performance gains come from what the optimizer learns, not from smaller pages. A tested demo compares pages, reads, plans and CPU for a plain index and a unique index. It also shows the error a duplicate causes.

Read More
Gouache painting of a small drawer cabinet on a sewing table with a vermilion thread spool inside one open drawer

Temp Table Scope in Dynamic SQL: Who Can See What

July 22, 2019
Pinal Dave
SQL Tips and Tricks
Dynamic SQL, SQL Scripts, SQL TempDB, Temp Table

Temp table scope decides what dynamic SQL and stored procedures can read. Tested demos show a child reading a parent table, a procedure that fails without it, a dynamic table shape and the error a typo causes. A card lists the rules.

Read More
Previous 1 … 68 69 70 71 72 73 74 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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