how many instances of s are there in:
q: automation query error in marketing cloud i am running the query using automation with the help of data extension, it is showing error like 

string or binary data would be truncated.


but i have the maximum field length also, what ever i have give the value it is showing error,how to rectify the error

any help appreciated

a: the issue is with smtpbouncereason. this field can return an excess of 4000 characters. to bypass this, remove leave the length field blank. this will force it to varchar(max) (over 4000 characters).
resources:


*

*override maximum character length

a: [incase anyone else comes across this issue...]
useful article on how to optimize sql queries:


*

*optimize sql query activities

relational data
the marketing cloud data environment, exposed via data extensions, is
  relational. it is possible to designate fields in data extensions as a
  primary key. the values stored therein can similarly be placed in
  another data extension to operate as a foreign key. by doing so, those
  two data sets can be logically linked to enable greater sophistication
  for data storage and analysis procedures.
any data extension spanning a cumulative field width greater than 4000
  characters must be avoided. avoiding excessive width is typically
  achieved by use of two data extensions that have been related via a
  primary/foreign key relationship.


user
In the text, there are 75 "s"s.
assistant