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
SQL Server UNION vs UNION ALL Error.

SQL SERVER – Puzzle – Solution – Why Does UNION ALL Work but UNION Produces Error?

January 8, 2018
Pinal Dave
SQL Puzzle
SQL Scripts, SQL Server, SQL Union clause

Here is the answer to my puzzle: why does UNION ALL work but UNION produces an error with a TEXT column? It comes down to how UNION removes duplicates.

Read More
Different mechanical gear types surround one table-like central hub

How to List All the Nonclustered Indexes of Your Table? – Interview Question of the Week #155

January 7, 2018
Pinal Dave
SQL Interview Questions and Answers
Clustered Index, ColumnStore Index, SQL Index, SQL Scripts, SQL Server

How do you list all the clustered and nonclustered indexes of your table, including columnstore? Here is the script I use in my performance health checks.

Read More
Log Shipping Tables Object Explorer.

SQL SERVER – Log Shipping Monitor Not Getting Updated

January 6, 2018
Pinal Dave
SQL Tips and Tricks
Log Shipping, SQL Error Messages, SQL Scripts, SQL Server, SQL Server Agent

The log shipping monitor stopped updating last_backup_file and last_backup_date for the primary, while every job ran fine. Here is how I traced it.

Read More
SQL Server UNION vs UNION ALL Error.

SQL SERVER – Puzzle – Why Does UNION ALL Work but UNION Produces Error?

January 4, 2018
Pinal Dave
SQL Puzzle
SQL Scripts, SQL Server, SQL Union clause

A puzzle with TEXT columns: UNION ALL works fine, but UNION produces error. Can you tell why? The hint is in how UNION removes duplicates.

Read More
Loose offcuts sit beside a cleanup brush while a separate set remains held by a clamp.

SQL SERVER – Slow Filestream Data Cleanup. What Should We Do?

January 3, 2018
Pinal Dave
SQL Tips and Tricks
Filestream, SQL Scripts, SQL Server

Slow Filestream Data Cleanup can follow deletion when files are still ineligible for garbage collection. One customer was running out of space.

Read More
One reserved work area is much larger than the material it currently holds, while another waits

How to List Queries With Memory Grant and Execution Plan? – Interview Question of the Week #154

December 31, 2017
Pinal Dave
SQL Interview Questions and Answers
SQL DMV, SQL Memory, SQL Scripts, SQL Server

A workshop customer suspected one of their queries used too much memory. Here is the script I gave them to list running queries with Memory Grant and plan.

Read More
SQL SERVER – xp_cmdshell and Net Use ERROR: The Local Device Name is Already in Use

SQL SERVER – xp_cmdshell and Net Use ERROR: The Local Device Name is Already in Use

December 29, 2017
Pinal Dave
SQL Tips and Tricks
Command Line, SQL Command, SQL Error Messages, SQL Scripts, SQL Server, SQL Stored Procedure

Mapping a share with net use through xp_cmdshell, I hit “The local device name is already in use”. Here is what causes this error and how to solve it.

Read More
Previous 1 … 108 109 110 111 112 113 114 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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