The filename will change depending on a record that needs to be inserted into a DB.

I will look further into writing a CLR SP. We are using 2005 so it...

oh, select db_name()...

Is there a way to get the currently selected DB name?

I forgot about using dynamic SQL.

Thanks...

The majority of these columns were originally char(10) or char(9) and we are trying to

standardize the column types so, yes, we do need to trim them.

The VB.net class that...

The SQLPLAN posted is from the correct DB and Table.

It's just that the indexes listed were from the same table on a different DB.

The correct indexes are in the screenshot.

Neither. However, I fixed it by removing all records in ptPayments per instructions from up above.

The table will be populated by a conversion routine from another DB.

I ran the DB Tuning Advisor on this and a couple other tables and it recommended 0 changes.

😉

I KNOW that something needs to be done to this table as well...

rbarryyoung (8/19/2008)

---

Well, the total IO is understandable, since you are updating every row in the table as well as every entry in 3 indexes, what surprises me is that the...

See image.

SQLPlan is attached.

No Triggers on this table.

Here are the indexes and keys:

Indexes:

[IX_ptLabResults]

columns: ([EMRApproved] ASC)

[IX_ptLabResults_2]

columns: ([MRN] ASC,

...

Something to remember...thanks!

Yes I figured that, it worked that way with 2005 connecting to 2000. However...

GilaMonster...

So can I use 2008 Management Studio on 2005 DBs without harming them? What I mean is can...