Invalid switch value

• Morten Stromme

  SSC Veteran

  Points: 290

  More actions

  October 4, 2005 at 8:42 am

  #110418

  When I run a delete on a big table (approximately 280 million records) I get this error message:

  SQL Server Assertion: File: , line = 499

  Failed Assertion = 'FALSE' Invalid switch value.

  Anyone who has any idea what that could be causing this?

  ---

  Kindest Regards,

  Morten

• Mike Metcalf

  SSCrazy Eights

  Points: 8763

  More actions

  October 4, 2005 at 9:03 am

  #594878

  I haven't seen this before but I would like to ask whether you are deleting all rows from the table or just a selection of them?

  If it's all then you should probably consider just truncating the table, if it's a selection then change your delete statement to do it in batches of 10000, which should cut down on the time taken to do the delete.

• Ian Yates

  SSCoach

  Points: 19738

  More actions

  October 5, 2005 at 12:36 am

  #595067

  That's an internal SQL error - you should send it to MS.  Or do a quick google search on it.

• Morten Stromme

  SSC Veteran

  Points: 290

  More actions

  October 6, 2005 at 2:12 am

  #595353

  I removed the indexes on the table and ran the deletion again. It worked fine and took 1/3 of the time.

  ---

  Kindest Regards,

  Morten

• Rudyx - the Doctor

  SSC-Forever

  Points: 43695

  More actions

  October 6, 2005 at 11:50 am

  #595591

  You might want to perform a few 'due diligence' things (even though your deletion worked).

  • recycle your SQL Server (yes reboot it)
  • look for *.DMP files
  • look for exception files
  • the dump and exception files can probably be deleted (unless you want to send them to MS PSS)

  I say this because you probably generated an exception and dump via the error mentioned. These activities are just 'normal' cleanup.

  RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."