Thanks for all of the replies.

Unfortunately, we have little control over the format of  the date field, since it is coming from a large international vendor's invoicing system. In the...

Lordy.  Thanks for the feedback on that.  It's very timely as I was going to actually try column store on a table or two and then put them into production. ...

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 4 years, 5 months ago by  DB_Newbie2007.
• This reply was modified 4 years, 5 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...