Home Forums SQL Server 2008 T-SQL (SS2K8) Rebuilding a table RE: Rebuilding a table

  • December 25, 2017 at 8:59 am

    #1973386

    ScottPletcher - Tuesday, December 19, 2017 2:29 PM

    If you can, TRUNCATE the table rather than DELETE all the rows, as trunc will be much less overhead (btw, in case you're wondering, a trunc can be rolled back in SQL Server, unlike in, say, Oracle).

    I am trying to put all my re-fresh code in one place.. so would not be able to do cross server truncate... and would have to put the update code in each database... granted not a big deal, but I like to have all the import of SAP data... and pushing out .. in one place.