·
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:
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.
administration AI Azure Backup/Recovery career career2 car update Cloud Computing coping database design databases Database Weekly DevOps disaster recovery encryption Friday Poll goals hardware Humor life Microsoft misc PASS powershell Redgate republish sabbatical security software development software development speaking SQL in the City SQLNewBlogger SQL Prompt SQL Saturday sql server syndicated T-SQL T-SQL Tuesday Tesla travel vacation windows words work
Voice of the DBA 
Comments
6 responses to “No More Mysterious Truncation”
Unfortunately not working for table variables 😦
LikeLike
But works for # tables 🙂
LikeLike
Good to know. I’m sure more work is coming here. Or I hope so
LikeLike
[…] fellow MVPs, I found that one of the most voted on feature requests was actually implemented. I blogged about this briefly, but in case you wonder, this is the message in SQL Server 2017 and […]
LikeLike
Excellent Steve! This will be an improvement.
LikeLike
Now…if ONLY they would put “Find And Replace” in the MS Access SQL window!
LikeLike