Heh... while the world insists...

A simple Scalar Function will cause the code to take about 7 times longer than either inline code or an iTVF that acts like a scalar function.  Please see the...

Congratulations but it doesn't help if we don't have...

Be very aware that versioning the rows can cause a massive amount of page splits, which causes massive fragmentation (when you first apply it because a version column will be...

First, be VERY aware that if you add the recommended PK (and you absolutely should), it WILL make a copy of the entire table before dropping the original heap (this...

• This reply was modified 6 years, 8 months ago by Jeff Moden. Reason: Made some minor corrects caught by Des Norton below. Thanks for the catches

Heh... while the world insists that you...

Micheal,

Unless you're just trying something simple out to learn how to use stored procedures, this should definitely NOT be a stored procedure.  Which is it?  Just a simple example for...

Scratch this guys, its only after posting that I see that it wouldn't update anyway as there's no difference in the values.

I'm just going to go sit in the...

The script is likely generating the correct amount of code and you're just having problems displaying it because of the limitations you spoke of in SSMS.  You can prove this...

This is the reason why I'm asking how many values in the SQLStatement table there are that fall in between the two numbers I provided.  It'll let us know...

There's no harm in having another post on a similar subject.  It  can become a bit tedious to have to wade through similar questions and responses on a single thread...

I guess my question would be, why did you set this instance up on a different domain?  That seems to be the real problem here.

Also, since you DO have a...

Inserts can be a problem if you are inserting multiple rows in a single statement.

There is no guarantee that the inserts will be performed in identity order unless you...

I have no thoughts on why OLEDB may be running slower than ADODB, but that has always been my experience.  I don't have the link for it but I also...

Yep... pretty typical.  But I do have to ask again, what's the size of the VARCHAR(MAX) entries?  More specifically, how many of the VARCHAR(MAX) entries are between 4047 and ~7000...