Ok, now its 2020 and SSIS has matured quite a bit.  I am bulk loading data using a web service task to call a SOAP web service.  One method call...

I found the registry hack for default locations worked for both SSMS and Visual studio but once you save, it becomes the last save location....which I am ok with.  However...

Thanks for the ANSI_Padding idea and will do that but I think I found the cause late yesterday afternoon. I am forced to use linked server object and when...

You nailed it sestell1! The reverse trick and appending the character showed I had 10 characters. Now if they are white space or invisible characters still remain to...

I was not aware of the padding on the right with LIKE and LEN, Good to know. I will try the alternate query (hopefully it will work with my...

There are reasons why I need like, but this is the simplest case that reproduces the behavior. I have tried exactly what you suggest and found the same issue....

I guess if you want to be like everyone else, than you should strive for mediocrity. However if you have pride in you work then you will strive for...

Impeccable timing sir. I just used this construct yesterday but did not experience this behavior. I will check today to make sure the lengths of my data types...

I agree, if homeland security used MS SQL server I would be impressed. No so much for the volume of data but the fact they believe the security...

Thank you for your hard work and dedication. This sight continues to prove a worthwhile source of relevant information.:)

"I'm a stickler for naming conventions on database objects. I am on a crusade to remove the information technology world of acronyms, and meaningless abbreviations - especially in the...

I would like to break this into the physical realm... 40 lap tops at 14"X12"X1" requires 3.888 cubic feet of storage space. Lets assume 5 business travel days...

Cool, so what I learned is:

Performance testing can be effected by many factors.

ISNULL can be slightly faster but is not an industry standard

...

As a fairly new SQL developer, I have often struggled with creating dynamic queries. This article is useful because it collects several techniques in one place. Some of...

Please remove, posed in the wrong area...sorry