Yes.  No typo's there.

I don't know what's causing the problem (although it may be "just" a missing driver on the app/client side) but my first thought is to get that firewall back up...

If the boxes use the same SAN, check with the SAN folks or vendor.  There is such a thing as "SAN Snapshots".   My first exposure to it was way back...

As a bit of a sidebar, your WHERE clauses for the start (>=) and end dates (<) are CORRECT.  Your calculation for end date is not.  You could miss some...

I have no reasonable explanation without being able to see an "actual execution plan".  I also understand that circumstances won't allow you to post one for this problem.

However, a possible...

I used SQL profile to trace SQL Statement and found user use insert bulk to insert data for a table, but the sql statment is too long (over 4000)...

Grant, Thank You for your thoughtful reply.  This will help me formulate better questions on my next post.  My goal is to find better solutions and learn new techniques...

To be honest, I've never seen anyone use it in the manner you've just described and that was a misunderstanding on my part because   I've only used it for columns...

To be honest, the column names are a bit cryptic but making some guesses about the column names, I'd say that the DES_OBSR_ENTD is likely the only column that would...

Why does your code setup full text catalogues on EVERY VARCHAR column in the table?  Is that really necessary?  Depending on the schema of your table, that could...

To complete the sentence you started in the title... "Crap Code" consisting of a lot or just a few common problems, insufficient indexes, improper joins, incorrect criteria, poor table/database design...

I know this sounds a bit "smarty pantsed" but, in order to not have PK conflicts, you have to stop sending or pulling... PK conflicts.

In other words, you need to...

For some reason (perhaps someone clicked on report instead of reply by accident), my previous post was reported as spam, so trying again...

I have a couple of questions...

1. Why does...

I guess my question would be... why are you creating a full text catalog for EVERY VARCHAR in the table?

I'll also ask why you're using code that has been deprecated...

Hi Jeff,

I still didn't understand in what type of pages will the LOB data get stored ? apart from 8k data page are there any other type of pages...