Covering Indexes in SQL 2005 – Results
After a few queries regarding my recent post on Covering Indexes, I decided to do a couple of tests to show you the results. Below are the actual execution plan results using the table structure and SQL query from…
Read More »Screenshots in Mac OS X from the terminal
Following on from yesterdays post about screen shots, if you want to script a screen grab, the following command will work. screencapture ~/Desktop/filename.jpgscreencapture ~/Desktop/filename.jpg Remember that you can get the list of options by using man: man screencapture
Read More »Screenshots in Mac OS X
The following key-presses will take a screen grab and save it to the desktop. Add CTRL to the mix to save it to the clipboard for later pasting. Full Screen Command-Shift-3. Selected Area Command-Shift-4 Then click and drag to select…
Read More »USB Remote Completed
I’ve made my remote, it’s as simple as it gets, with a momentary push switch. Behold the monstrosity that is my USB camera remote: It does look like a detonator but I’m hoping when plugged into two cameras…
Read More »Flush DNS Cache on Mac OS X
Go to a terminal window and type: dscacheutil -flushcachedscacheutil -flushcache
Read More »Editing your hosts file in Mac OS X
So you need to edit your hosts file? It’s path is /etc/hosts but being a system file, you’ll need to use sudo to get to it. Open a terminal and type: sudo vim /etc/hostssudo vim /etc/hosts Now, you’re…
Read More »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 »