Home Forums SQL Server 2008 SQL Server 2008 - General Qusestion on delete job RE: Qusestion on delete job

  • October 22, 2012 at 4:31 am

    #1551290

    baabhu (10/20/2012)

    Brandie Tarvin (10/19/2012)

    I have an odd question. Why do you need to delete 10000 records from your database every 4 minutes?

    This is an OLTP system with tokens needs to be updated every 4 minutes. We use staging table to do updates and move to the final table and remove the rows from staging.

    Why not use TRUNCATE?

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.