Low CPU Load Delays with SQL
Use WAITFOR to pause scripts while using minimal CPU overhead. WAITFOR TIME ’09:15′; –Wait until 9:15am WAITFOR DELAY ’00:00:05′ –Wait for 5 secondsWAITFOR TIME ’09:15′; –Wait until 9:15am WAITFOR DELAY ’00:00:05′ –Wait for 5 seconds It is…
Read More »Covering Indexes in SQL 2005
For some strange reason, covering indexes are not used or understood as much as they should. To quote Microsoft… “A Covering Index is a nonclustered index built upon all of the columns required to satisfy a SQL Server…
Read More »Making the USB Remote
I’ve picked up my pieces from Maplin and started building my remote. I’ve been playing around and found that with my cameras, they seem happy receiving 9 volts to trigger them. This makes the circuit very simple. Disclaimer:…
Read More »A few things have arrived
I ordered a few items off the Bay of E and am getting excited about this project. Here is the Flash Bracket I ordered: It’s just a straight rail with TWO screws for mounting the cameras. It’s already…
Read More »Giant Kiwi – No News is not Good News
I’m trying to find out the status of the markings on the land at the moment. Hopefully they are still visible and my work wasn’t in vain. For now though, you’ll have to make do with a view…
Read More »Dual camera 3D Photography
While back in New Zealand I picked up a couple of the “Canon Ixy Digital 10” digital camera. Yes, it’s actually a Japanese model – I got then through Parallel Imported Ltd who as the name suggests, Parallel…
Read More »Giant Kiwi – Not Happening this Trip
It’s all gone a bit to custard. The weather is still too wet for me to finish the kiwi and on top of that, I went into hospital last week and had my Appendix removed. The net result…
Read More »Giant Kiwi – Weather Problems
The winter this year in New Zealand must be one of the wettest for a couple of years. I’ve been unable so far to go back and finish the wide line or to fly over and take photos…
Read More »Giant Kiwi – Widening the Line
After the successful flight overhead to check the draft of the kiwi, it was time to widen the line up a bit. I had planned to use a high pressure paint sprayer, but due to lack of electricity…
Read More »Giant Kiwi – First Impressions from Above
I finally had a day where the weather wasn’t too bad so I took the opportunity to hire a plane (I have my pilots license) and fly over the kiwi. This wasn’t the official photography run, just a…
Read More »