Programmatically deleting all records in a table

[Frothingslosh]

I have to admit to being curious now as to how long it would take to delete the contents from my biggest table at work via the row-by-row method, but I'm pretty sure it would result in my boss shooting me before firing me. And copying the table then running the test on that isn't exactly an option. I'm not even sure we have enough space for me to do that.

 

[isladogs]

I haven't tried deleting row by row but did try appending row by row (or RBAR as I now call it thanks to Minty)
When I tried the latter on a large table as part of my earlier speed tests, I ran out of system resources or hit the 2GB file size limit!

 

[Frothingslosh]

I believe it.