trace Flag 610

• Bhuvnesh

  SSC Guru

  Points: 59351

  More actions

  July 4, 2014 at 3:47 am

  #309746

  1. Does trace flag also give benefit when we delete or insert data into #temp tables ?

  2. Does it help in simple recovery mode?

  3. Do the below help ?

  ---Code

  dbcc traceon 610

  insert into employee (with tablock)

  select ..........

  dbcc traceoff 610

  -------Bhuvnesh----------
  I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

• Igor Micev

  SSC-Dedicated

  Points: 33110

  More actions

  July 6, 2014 at 7:31 am

  #1727225

  The following article should en-clear about

  http://msdn.microsoft.com/en-us/library/dd425070(v=sql.100).aspx

  Igor Micev,My blog: www.igormicev.com