Truncate/Delete All Data in Database

I found this awesome script to easily delete all data in all the tables of a database. There might be an issue with large tables, or if some constraints were previously disabled then you will need to disable them again afterwards. Here's the T-SQL, I found it here

-- disable referential integrity
EXEC sp_MSForEachTable 'ALTER TABLE ? NOCHECK CONSTRAINT ALL'
GO

EXEC sp_MSForEachTable '
IF OBJECTPROPERTY(object_id(''?''), ''TableHasForeignRef'') = 1
DELETE FROM ?
else
TRUNCATE TABLE ?
'
GO

-- enable referential integrity again
EXEC sp_MSForEachTable 'ALTER TABLE ? CHECK CONSTRAINT ALL'
GO

Amsterdam pics

I've just posted my Amsterdam pictures after Bo had to retrieved our travelgoats.ca password from our old harddrive. Here are the Amsterdam pictures.

Moving around...

No, we didn't move flats. I'm having a great time in the little town of Tring. Nice and quiet and a lot of fresh air. I'm not missing the city at all. People come to our town on the weekends to relax. It reminds me of Banff, with a lot fewer shops. Bo has really picked up on model gliding. He's got magazine, books and picked up a model gliding mentor too. We've been going to Ivinghoe Beacon the last two weekend to learn and fly his glider.

As for work, we're always busy. The way that this project is going, it reminds me of the paper I wrote at UC, which highlighted my days as an intern student, working without much guidance of requirement documents. On top of that, let's add in a touch of unrealistic deadlines, blend it with a bowl of hope and pry, put it in a bigger bowl, seal it up and let stand for 2.5 months...

More about work. We came in the other day and were stunned that our computers were gone. Thoughts were racing through my mind, like did we get axed or who took my cup? It turned out that our team moved to a different location. I think to myself, WOOHOO, we're no longer in the call center. However, they put us in the warehouse! Does this remind you of the TV show, IT Crowd? On the plus side, the ceiling was a lot higher so in comparison, the air was better. Though it could be quite loud at times. It's no longer the sound of people taking on the phone, but replaced by the machines chatting away. I wonder if we're ever going to be moved to a proper office...

Just a week later, we were no longer in the warehouse. We got kicked out because they needed that space. We had to move again but there was no room for us anywhere. So they converted a meeting room for us. It was very small and stuffy. It had no air system installed and had a small window. They stuck 6 of us in there with 6 computers. HOT AND STUFFY! But they promised to get us a mobile air con unit, and we also nicked a fan somewhere to push the warm air around. At least it was quiet in here and we were one door away from the lunch room. Very handy in getting coffee and tea...

The mobile air con unit finally arrived a few days later. Not a moment too soon, cause we were contemplating on wearing beach wear to work. It got so hot the last few days that the tiny unit barely had any effect. We managed to nick two more fans from somewhere and I came up with the awesome idea of putting a fan in front of the air con unit to help blow the cold air out a bit further. I was desperately trying to stay focus on writing 10,000+ lines of code per day, but in this heat, I was struggling to write even 1000 lines...

Eventually (a week later), we were blessed by the god of water by getting cats and dogs thrown at us. The heat finally subsided and I'm back to my peak levels of writing 10,000+ lines of code! All is well.