If the source definition for the column is varchar(20) - why are you trying to force that into a char(6) column? 

Long story... but in a nutshell, the "source" table...

Jeff,

Thanks for the update. For the initial problem, we spent over 5 hours trying to look at the data to figure out what was going wrong.

• Len() and DataLength()

• Different...

Jonathan,

Thanks for the suggestion. We did think of that early on and tried a few different combinations, i.e.,

AccountNo LIKE '%[^a-zA-Z0-9]%'
AccountNo LIKE '%'+CHAR(13)+'%' OR AccountNo LIKE '%'+CHAR(10)+'%' ...

We just discovered another process that is having a similar issue. It appears to be where the field size in the "source" table (which contains the non-clustered columnstore index) is...

• This reply was modified 6 years, 1 months ago by DB_Newbie2007.
• This reply was modified 6 years, 1 months ago by DB_Newbie2007.

Its not just the data but how the data is used and the mathematical models they help to create. I suggest reading the book Weapons of Math Destruction by...

Thanks immensely, Steve! I sent the information to our development team so they can make the appropriate modifications to our table(s) and code. 

 I love surprises but *not* "gotchas"....

WOW! That is a lot of joins on the same table/view!

My experience has been, if you need to join on the same table but with multiple criteria, it might...

Thanks for all of the inputs so far.

FYI, since this is a somewhat ambiguous question...

• Almost all of the tables have INT/VARCHAR datatypes. Definitely no BLOB, Text, NText,...

What's the best way to find the SQL statements you need to tune? Here are some of the things we do (and, as we get more knowledgeable, we grow and...

Besides RedGate's SQL Prompt, we use AutoHotKey to automate certain key sequences. It is not a SSMS add-in but rather a Windows app, but we use it exclusively for SQL...

I was investigating the same issue and discovered that you need to do the following, when the login does not have dbo or sa permissions:

GRANT VIEW DEFINITION ON [Name...

Thanks for the reply. However, what I am looking for is running this:

EXEC dbo.usp_MyStoredProcedure -?

The result would just list the parameters in the stored procedure and acceptable input(s) for...

Peter, thanks for the link. Honestly, this is one case I never would have thought about checking BOL...

We use CLRs (have for some times) with custom C# code. Previously, it ran on all of our customer-facing SQL servers (non-SSRS report servers), now only one server uses it...

You could write a script to BCP out the data?

Here is something I run to generate data from a table to convert it into a SELECT statement:

USE MyDatabase

Go

DECLARE...