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
Dialog box displaying error.

SQL SERVER – UNION With TEXT DataType Returns Error but and UNION ALL Works – Reasons

January 3, 2015
Pinal Dave
SQL Tips and Tricks
SQL Union clause

Why does UNION with TEXT datatype return an error while UNION ALL works? It comes down to how UNION removes duplicate rows. Here is the reason.

Read More
Feature Selection Window.

SQL SERVER – Fix – Missing “Mirroring” and “Transaction Log Shipping” option in the Database Properties

January 2, 2015
Pinal Dave
SQL Tips and Tricks
SQL Error Messages

The Mirroring and Transaction Log Shipping options were missing in Database Properties for my freshly created database. Here is what caused it and the fix.

Read More
SQL SERVER - Year 2014 Reflections by Tim Radney - Notes from the Field #060

SQL SERVER – Year 2014 Reflections by Tim Radney – Notes from the Field #060

January 1, 2015
Pinal Dave
SQL Performance
Notes from the Field, Shrinking Database

Instead of New Year’s resolutions, Tim Radney suggests looking back. Here are his Year 2014 reflections, a great way to plan the year ahead.

Read More
An old chair with one new leg being glued in, held by a red clamp

Refactoring Old T-SQL One Procedure at a Time

January 1, 2015
Pinal Dave
SQL Tips and Tricks
SQL Coding Standards, SQL Server, SQL Stored Procedure, Testing

Begin refactoring old T-SQL with one procedure, repeatable inputs, duplicate-aware result checks, measured reads, and a simple change log.

Read More
Grouped extension plugs separated from a female connector

Exporting and Sharing Registered Server Groups in SSMS

December 31, 2014
Pinal Dave
SQL Tips and Tricks
SQL Connection, SQL Instance, SQL Server Management Studio

One shared server list can save you from running a query on the wrong server. Here is how to build it, export it without passwords and use it.

Read More
SQL union error dialog.

SQL SERVER – UNION and UNION ALL with TEXT DataType – Observation

December 30, 2014
Pinal Dave
SQL Tips and Tricks
SQL Union clause

UNION fails on a TEXT column with Msg 5335, yet UNION ALL with TEXT datatype works fine. Here is the code so you can try the difference yourself.

Read More
Select query with divide by zero error.

SQL SERVER – Puzzle – Why Divide by Zero Error

December 29, 2014
Pinal Dave
SQL Puzzle

Why does SELECT 10000/(17/17/17) return a divide by zero error? A new puzzle, similar to my decimal rounding one but with a different approach.

Read More
Three raised glasses waiting over a garden table while a fourth is still being filled

CXSYNC_PORT and CXSYNC_CONSUMER Waits in Parallel Queries

December 28, 2014
Pinal Dave
SQL Performance
MAXDOP, Parallel, SQL Server, SQL Server 2022, SQL Wait Stats

Investigate CXSYNC_PORT with session wait deltas, parallel plan exchanges and thread rows before testing a query-level MAXDOP change.

Read More
Collated nail strip with a defined end beside a loose nail heap

The Last Entered Row: Why a Table Needs an Ordering Column

December 27, 2014
Pinal Dave
SQL Tips and Tricks
SQL DateTime, SQL Identity, SQL Order By

A table has no last row until you define one. Here is how identity, event time and ties give different answers.

Read More
SQLAuthority News - Presented on Database Worst Practices at SQL Live, Orlando - November 29, 2014

SQLAuthority News – Presented on Database Worst Practices at SQL Live, Orlando – November 29, 2014

December 26, 2014
Pinal Dave
SQLAuthority News
SQLAuthority Author Visit

I presented Database Worst Practices at SQL Live 2014 in Orlando in November. You can read the title and abstract of my demo-oriented session.

Read More
Previous 1 … 277 278 279 280 281 282 283 … 593 Next
  • Books
  • Testimonials
  • Privacy Policy

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