October 25, 2018 at 10:37 am
Chris Harshman - Thursday, October 25, 2018 10:03 AMWow, just wow, I just got a notice about Microsoft has finally improved the error "Binary or string data would be truncated"completed
This feature is shipped in SQLServer 2017 CU12, SQL Server 2019 CTPand upcoming SQL Server 2016 CP2 CU. Read more at https://blogs.msdn.microsoft.com/sql_server_team/string-or-binary-data-would-be-truncated-replacing-the-infamous-error-8152/
="http:>
OMG!!! Only a couple decades to fix what should have been relatively simple. This has been a major thorn in my side every time I run into it. Glad this finally going to be addressed.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
October 25, 2018 at 10:54 am
Sean Lange - Thursday, October 25, 2018 10:37 AMChris Harshman - Thursday, October 25, 2018 10:03 AMWow, just wow, I just got a notice about Microsoft has finally improved the error "Binary or string data would be truncated"completed
This feature is shipped in SQLServer 2017 CU12, SQL Server 2019 CTPand upcoming SQL Server 2016 CP2 CU. Read more at https://blogs.msdn.microsoft.com/sql_server_team/string-or-binary-data-would-be-truncated-replacing-the-infamous-error-8152/
="http:>
OMG!!! Only a couple decades to fix what should have been relatively simple. This has been a major thorn in my side every time I run into it. Glad this finally going to be addressed.
I've had to rewrite queries quite a few times with lots of column a few times to "SELECT MAX(LEN(col1))... GROUP BY ..." then compare the lengths to the table definition just to find out which column is the culprit. So a welcome fix.
October 25, 2018 at 12:15 pm
I may have to go burn down our local news radio station...
During the lead-in to a story they've been talking about all day, they keep playing "It's beginning to look a lot like Christmas"
IT'S TOO EARLY!
I don't CARE that the state capitol is getting their XMas tree today!
We haven't even reached Halloween yet!!!
/me goes into a dark corner and curls up sucking my thumb and whimpering
October 25, 2018 at 12:17 pm
Jonathan AC Roberts - Thursday, October 25, 2018 10:54 AMI've had to rewrite queries quite a few times with lots of column a few times to "SELECT MAX(LEN(col1))... GROUP BY ..." then compare the lengths to the table definition just to find out which column is the culprit. So a welcome fix.
yeah, somebody here pointed it out a week or so ago (Grant? Hugo? forget) but very happy with that one
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
October 25, 2018 at 12:19 pm
jasona.work - Thursday, October 25, 2018 12:15 PMI may have to go burn down our local news radio station...
During the lead-in to a story they've been talking about all day, they keep playing "It's beginning to look a lot like Christmas"IT'S TOO EARLY!
I don't CARE that the state capitol is getting their XMas tree today!
We haven't even reached Halloween yet!!!
/me goes into a dark corner and curls up sucking my thumb and whimpering
"I will honor Christmas in my heart, and try to keep it all the year. I will live in the Past, Present and Future." ~ Ebenezer Scrooge
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
October 25, 2018 at 1:20 pm
jasona.work - Thursday, October 25, 2018 12:15 PMI may have to go burn down our local news radio station...
During the lead-in to a story they've been talking about all day, they keep playing "It's beginning to look a lot like Christmas"IT'S TOO EARLY!
I don't CARE that the state capitol is getting their XMas tree today!
We haven't even reached Halloween yet!!!
/me goes into a dark corner and curls up sucking my thumb and whimpering
The Christmas decoration went up in the complex my office is in at the beginning of this month. We don't even have thanksgiving in the way. 🙁
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 25, 2018 at 3:06 pm
jasona.work - Thursday, October 25, 2018 12:15 PMI may have to go burn down our local news radio station...
During the lead-in to a story they've been talking about all day, they keep playing "It's beginning to look a lot like Christmas"IT'S TOO EARLY!
I don't CARE that the state capitol is getting their XMas tree today!
We haven't even reached Halloween yet!!!
/me goes into a dark corner and curls up sucking my thumb and whimpering
Well, that's OK, some of the stores here had their Halloween displays up the first week of August so everyone is sick of that by now. :hehe:
October 25, 2018 at 3:08 pm
GilaMonster - Thursday, October 25, 2018 1:20 PMjasona.work - Thursday, October 25, 2018 12:15 PMI may have to go burn down our local news radio station...
During the lead-in to a story they've been talking about all day, they keep playing "It's beginning to look a lot like Christmas"IT'S TOO EARLY!
I don't CARE that the state capitol is getting their XMas tree today!
We haven't even reached Halloween yet!!!
/me goes into a dark corner and curls up sucking my thumb and whimperingThe Christmas decoration went up in the complex my office is in at the beginning of this month. We don't even have thanksgiving in the way. 🙁
Lordy... we're still almost a week away from Halloween.
--Jeff Moden
Change is inevitable... Change for the better is not.
October 26, 2018 at 1:14 am
Jeff Moden - Thursday, October 25, 2018 3:08 PMGilaMonster - Thursday, October 25, 2018 1:20 PMjasona.work - Thursday, October 25, 2018 12:15 PMI may have to go burn down our local news radio station...
During the lead-in to a story they've been talking about all day, they keep playing "It's beginning to look a lot like Christmas"IT'S TOO EARLY!
I don't CARE that the state capitol is getting their XMas tree today!
We haven't even reached Halloween yet!!!
/me goes into a dark corner and curls up sucking my thumb and whimperingThe Christmas decoration went up in the complex my office is in at the beginning of this month. We don't even have thanksgiving in the way. 🙁
Lordy... we're still almost a week away from Halloween.
The local oiks have been setting off fireworks for the last two weeks and we're still two weeks from Bonfire Night! I, of course, was never a local oik setting off fireworks early :Whistling:
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
October 26, 2018 at 5:05 am
Am I really the only one annoyed by Mr. Ansi's "Please post DDL and follow ANSI/ISO standards when asking for help." response to the debate when the question didn't even revolve around needing code but was just a "where's the proof" kind of question.
EDIT: Nevermind. It appears to be part of his signature.
October 26, 2018 at 6:16 am
GAH.
I hate having a SSIS package fail and fail again when being run from a job, but works fine from the desktop. And I look and look and look for the problem stated in the error file, but can't find the bloody problem because everything looks right. So then I try closing VS, reopening it, removing the local config file, adding it back, and eventually it's working fine in the job because somehow the problem was a ghost value caught in the package's cache somewhere and not a real problem at all.
Four hours it took me to clear out this ghost value that didn't exist but did. <headdesk>.
October 26, 2018 at 6:48 am
Brandie Tarvin - Friday, October 26, 2018 6:16 AMGAH.I hate having a SSIS package fail and fail again when being run from a job, but works fine from the desktop. And I look and look and look for the problem stated in the error file, but can't find the bloody problem because everything looks right. So then I try closing VS, reopening it, removing the local config file, adding it back, and eventually it's working fine in the job because somehow the problem was a ghost value caught in the package's cache somewhere and not a real problem at all.
Four hours it took me to clear out this ghost value that didn't exist but did. <headdesk>.
This is one of the reasons I hate SSIS so much. When something simple goes wrong it can take hours to figure out exactly what, and where. There are loads of SSIS packages here and many of them aren't sufficiently robust to tolerate even small environmental changes so they break. Most of them would be much easier to fault-find & fix if they were agent-driven stored procedures but no, some idiot liked shiny new SSIS. Technical debt to hell and back. TFIF and an early-finish one, to boot.
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
October 26, 2018 at 6:59 am
ChrisM@Work - Friday, October 26, 2018 6:48 AMBrandie Tarvin - Friday, October 26, 2018 6:16 AMGAH.I hate having a SSIS package fail and fail again when being run from a job, but works fine from the desktop. And I look and look and look for the problem stated in the error file, but can't find the bloody problem because everything looks right. So then I try closing VS, reopening it, removing the local config file, adding it back, and eventually it's working fine in the job because somehow the problem was a ghost value caught in the package's cache somewhere and not a real problem at all.
Four hours it took me to clear out this ghost value that didn't exist but did. <headdesk>.
This is one of the reasons I hate SSIS so much. When something simple goes wrong it can take hours to figure out exactly what, and where. There are loads of SSIS packages here and many of them aren't sufficiently robust to tolerate even small environmental changes so they break. Most of them would be much easier to fault-find & fix if they were agent-driven stored procedures but no, some idiot liked shiny new SSIS. Technical debt to hell and back. TFIF and an early-finish one, to boot.
I think that the root problem is simply "just because you can do it in SSIS doesn't mean that you should"😉
😎
October 26, 2018 at 6:59 am
ChrisM@Work - Friday, October 26, 2018 6:48 AMTFIF and an early-finish one, to boot.
Or, as we say here, "POETS Day".
Thomas Rushton
blog: https://thelonedba.wordpress.com
October 26, 2018 at 7:13 am
Eirikur Eiriksson - Friday, October 26, 2018 6:59 AMI think that the root problem is simply "just because you can do it in SSIS doesn't mean that you should"😉
😎
Let's not beat about the bush Eirikur..."Try to use the right f..g tool for the job"!
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
Viewing 15 posts - 62,761 through 62,775 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply