Month: November 2008
SQL Joins and Applies – Understanding OUTER JOIN
This is part of a four part post series on SQL Joins and Applies. If you want to follow the examples given, you can get the T-SQL to create the tables, function and test data from my earlier…
Read More »SQL Joins and Applies – Understanding CROSS JOIN
This is part of a four part post series on SQL Joins and Applies. If you want to follow the examples given, you can get the T-SQL to create the tables, function and test data from my earlier…
Read More »SQL Joins and Applies – Understanding INNER JOIN
Understanding INNER JOIN. The other posts in this series are: SQL Joins and Applies – Understanding CROSS JOIN SQL Joins and Applies – Understanding OUTER JOIN SQL Joins and Applies – Understanding APPLY This is part of a…
Read More »Creating ISOs in Mac OS X
Here are step by step instructions on how to create an ISO from a CD or DVD in Mac OS X. First, insert the CD/DVD and open terminal. Type in: drutil status Your results may vary, here is…
Read More »SQL Joins and Applies – Test Data
I’m writing a four part series on Joins and Applies in SQL. Below is the T-SQL to create the two tables and a function used to explain SQL Joins and Applies. –CREATE A TABLE VALUED FUNCTION –FUNCTION IS…
Read More »High Performance Bulk Inserts into SQL – Considerations
Did you know that simply setting the Database Recovery Model to BULK_LOGGED does not guarantee minimal logging when inserting? At the very least, for performance: Recovery Model should be set to BULK_LOGGED. Destination table should not be replicated….
Read More »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 »