No More Mysterious Truncation

If you read the Microsoft White Paper on SQL Server 2019, there’s a gem buried on page 17. It mentions a trace flag, which some of you might appreciate.

Here’s a little repro:

 2018-09-25 15_00_20-SQLQuery1.sql - Plato_SQL2019.Sandbox (PLATO_Steve (65))_ - Microsoft SQL Server

As you can see, the plee I made has actually been heard. I don’t know if they listened to me, or if the collective complaints over the year grew to the point that this got fixed.

In any case, thank you, Microsoft. This is a very nice enhancement.

About way0utwest

Editor, SQLServerCentral
This entry was posted in Blog and tagged , . Bookmark the permalink.

6 Responses to No More Mysterious Truncation

  1. Grzegorz Łyp says:

    Unfortunately not working for table variables 😦

  2. Grzegorz Łyp says:

    But works for # tables 🙂

  3. way0utwest says:

    Good to know. I’m sure more work is coming here. Or I hope so

  4. Pingback: An Open Thank You to the Microsoft SQL Server Team | Voice of the DBA

  5. Mark T says:

    Excellent Steve! This will be an improvement.

  6. Brian Battles WS1O says:

    Now…if ONLY they would put “Find And Replace” in the MS Access SQL window!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.