It was late at night, and I had just finished loading all of the incoming data into my
intermediary system. Of course, I had used scripts to organize the various modifications
needed to convert the data to fit the new system. I had been doing this for about 27 hours
straight, so all of the stored procedures I used were in the same query window. I??™d just
highlight what I wanted to run. (You should know that I??™m prone to typos when I write.)
For some strange reason, I highlighted the ???cleanup??? procedure and executed it. That
stored procedure simply truncated every table in my intermediary system, including the
lookup tables I used during conversion. As I hit F5 to run the query, I realized what I had
done. Time crawled to a stop as I pushed the button. I could hear in classic slow-motion
the sound of my brain saying, ???NOOOOOOOOO!???
The Result
Because the stored procedure was simply executing TRUNCATE TABLE statements, everything
happened quickly. The stored procedure finished in about two seconds. That??™s it; it
was done. I had to start over from scratch. Of course, I had to reload all of the data,
including the lookup tables.
Pages:
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536