• TheSQLGuru (1/4/2011)


    1) why in the world are you concerned about a 279MEGABYTE transaction log?? If your disk space is that tight you have some very serious issues to deal with.

    2) sort in tempdb is a wonderful thing for numerous reasons such as being able to split IO usage, avoiding tlog us in primary db, better contiguousness of data layout potentially

    You're right. a 279mb log isn't big time but as I said, it's not an issue right now. I was interested in how others might have handled the same situation. Perhaps I could learn from their experience and leverage that if this situation were to ever arise in a more important production database.

    ______________________________________________________________________________________________
    Forum posting etiquette.[/url] Get your answers faster.