Are you using the GUI to change the table, or directly issuing an Alter Table command from Management Studio, or something else?

Also, how big is the table you are altering?...

I've done...

I have to disagree. Even if the performance of that particular query "doesn't matter", you have to ask why...

Robert Frasca (10/13/2008)

---

Don't mean to be fussy but a table can have a PK and be a heap table. A table without a clustered index is part of the...

Matt Miller (10/14/2008)

---

Let's not forget one of the biggest factors the various models forget to deal with...the power the model itself wields on the underlying system it was designed to...

Use is most important. What's the point to indexing a column you never select by?

A good way to do it is pick the columns that appear in Where/Join the...

I guess I don't understand what method you are using to upload all this into the database. Are you using some sort of distributed transaction for all of it?

Try something like this:

acctID Ntext

1 ...

I'm going to have to go with not an SQL issue. Network or client machine or something related to that.

Instead of passing a file location, what you might want to do is have the .NET app upload the file to a standard location, and give it a unique name...

The problem I see with the models they used is that, as is so often the case, their precision exceeded their accuracy. It's one of the most common mistakes...

With the whole, "same name as thousands of others" thing going, I've actually wondered recently if the celebrity thing of truly odd names for their kids might be more of...

That's correct.

I have to say, I've had a few places where a heap table (no PK, no clustered index) was useful to me, mainly in places where I needed to do...

I can't imagine going through this much effort to create a fake identity when, in fact, the FBI says that stealing an actual identity is usually just a question of...