update for bulk logged
let's say you need to update 60 million rows, correcting the company code- could that be considered bulk logged , so can reduce log space usage at that time.
any other option for updates and log, while in FULL mode/
any other option for updates and log, while in FULL mode/
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
lcohan- very good thought-
but why restrict it to char only, why not int?
but why restrict it to char only, why not int?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for the very good idea..
ASKER
would bulk_logged help at all, or is it just the same as FULL for one line updates, like the above? (update all rows for a column with the same data).. is that considered bulk operations?