He already tried that.

Maybe I misread it... gonna recheck it Thuesday.

Just jumping in here... the computed columns are always calculated on the fly UNLESS they are indexed. However, to be indexable, the formula must be deterministic. This one...

That's why I'm not repeating this anymore .

Now we're finishing each other's sentences... just like married peoples .

What Noel is getting at is "Did you put SP4 on already?"

The server will always use all ram available whenever possible. If it can, the whole DB will be in ram.

Now you're assuming that the field is indexed .

Seriously 100 teachers adding 35 records each shouldn't affect the server at all (unless it's already too stressed)... I can do batch inserts of 250K records in 2-3 seconds on...

Since we're making valid points >>

update... where charindex ('-', FieldName, 1) > 0 so that you update only the rows that need changing.

I understand, must be on a tight deadline since you can't take 3 more minutes to Help us help you.

Seriously, try reading what Ray and I said.

I must be using invisible screen ink or something .

Programmers, lazy??

Not possible .

... and then update the script of the procs, views, functions to include the dbo. Because if you script then out and reapply them you're gonna have to do...