If your going to Express or Web it is a downgrade which is why you may not find it if you have been searchign for upgrades.

I would suggest taking...

I understand the number sounds high especially if you are a small shop.

I would suggest 2 things one on the IIS server go into perfmon and get a running count...

Yes Agreed.

The transaction log does not shrink, unless speciffically commanded to do so. And then it is external.

It is made of of Virtual Log Files, they never get zero'ed...

sorry syntax you are correct. I meant internal shrinking not external, which is truncating. And yes the command was only for SQL 2000, I didn't mention that above...

SQL 2005 doesn't have resource Pool management like SQL 2008, so no for doing anything per user.

as far as limiting to a processor you can use sp_configure and affinity mask...

they are absolutely right, deleting the log makes the whole thing unstable.

Before I knew better, I had situations when I first became an accidental DBA (before i became one on...

Once Again, I think it depends. If you get the page io latch error then it can only be one thing. depending on capacity and load everything eventually...

.....well i'm down to a C..... 😀 I guess I can be President

I only tossed that out becase of the 10 GB limit, you are right though it would grow again in the next batch, so a shrink would not help.

Simple recovery...

My appologies, I don't know of anything that would be a non-custom solution.

My Oracle DBA suggested breaking the update into seperate statements by some sort of range value, and dumping/shrinking the transaction log in between updates.

Sorry but it is not possible, turning off logging would break the Durability part of the A.C.I.D. properties of a database.

http://support.microsoft.com/kb/59462

Microsoft has not allowed it since 7.0 was rolled out.

I...

Learn something new every day....and man there is a lot to learn.

the limit on include columns is 1023.

http://msdn.microsoft.com/en-us/library/ms190806.aspx

I stand corrected, when you remake the non clustered index I would make...

Yeah okay back down to a B, but heck you only need a C average to be president

I was waiting for it after I re-read and saw it was unique...

does the table have a clustered index?

you cannot do a covering index as the limit is 16 columns, I would deffinitally add a clustered and re-create a non clustered on...