October 4, 2005 at 8:42 am
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?
Morten
October 4, 2005 at 9:03 am
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.
October 5, 2005 at 12:36 am
That's an internal SQL error - you should send it to MS. Or do a quick google search on it.
October 6, 2005 at 2:12 am
I removed the indexes on the table and ran the deletion again. It worked fine and took 1/3 of the time.
Morten
October 6, 2005 at 11:50 am
You might want to perform a few 'due diligence' things (even though your deletion worked).
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."
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy