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 heaped woodpile beside a neat stack of logs on a vermilion pallet

Index Build Speed: Which Rebuild Settings Change the Time

March 1, 2021
Pinal Dave
SQL Performance
SQL Index, SQL Scripts, SQL Server, SQL TempDB

Index build speed depends on rebuild or reorganize, MAXDOP, ONLINE, SORT_IN_TEMPDB and the recovery model. This post times each choice on a million row table and measures the log under each recovery model. It shows which one changes the clock and which changes only the log.

Read More
An open fitted drawer and corresponding sample tray preserve their compartment sequence.

SQL SERVER – Get Column Names

February 25, 2021
Pinal Dave
SQL Tips and Tricks
SQL Column, SQL Scripts, SQL Server, SQL Stored Procedure

I Get Column names using a schema-qualified table and a defined column order. The four methods use corrected filters.

Read More
Mixed wooden pieces in one shallow bowl beside three small bowls containing sorted matching pieces.

Normalisation in Plain Words, and When to Stop

February 24, 2021
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Scripts, SQL Server

Understand normalisation through one order example, then decide when a reporting copy is worth the cost of keeping duplicated data consistent.

Read More
Gouache painting of a small blank cream luggage tag tied with a vermilion string to the handle of a brown suitcase, a second suitcase standing behind it

Error 2714: There Is Already an Object Named MyFirstTable

February 23, 2021
Pinal Dave
SQL Tips and Tricks
Primary Key, SQL Constraint and Keys, SQL Error Messages, SQL Scripts

Error 2714 reported that MyFirstTable already existed, but the client found no such table. A query on sys.objects showed a primary key constraint with that name on another table. Creating the table under another name, or renaming the key, fixes it.

Read More
Gouache painting of two identical windows showing the same garden at night, with a small potted plant between them

AT TIME ZONE Twice: Convert UTC to Local Time in SQL Server

February 22, 2021
Pinal Dave
SQL Tips and Tricks
SQL DateTime, SQL Function, SQL Scripts, SQL Server

AT TIME ZONE twice converts UTC to local time in SQL Server. The first use labels a plain value as UTC and the second converts it. A demo shows the common one step mistake, stores in three cities, and the missing and repeated hours of daylight saving.

Read More
Gouache painting of a windowsill of cacti with the tallest one wearing a vermilion cork cap

Escape Text for JSON: Build Valid JSON With STRING_ESCAPE

February 16, 2021
Pinal Dave
SQL Tips and Tricks
JSON, Quotes, SQL Scripts, SQL Server, SQL String

To escape text for JSON, pass each value through STRING_ESCAPE, so JSON built by hand stays valid. A demo shows which characters it escapes and which it leaves alone. It also shows when JSON_MODIFY and FOR JSON make it unnecessary.

Read More
Forwarded Records and Performance

Forwarded Records and Performance – SQL in Sixty Seconds #155

February 15, 2021
Pinal Dave
SQL Tips and Tricks
SQL Data Storage, SQL Heap, SQL in Sixty Seconds, SQL Scripts, SQL Server

Forwarded records make SQL Server read extra pages when it scans a heap. In this SQL in Sixty Seconds video, I explain forwarded records and performance.

Read More
Previous 1 … 19 20 21 22 23 24 25 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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