The APPLY operator is similar to the JOIN operator, however it specifically allows you to use table functions with parameters to join the results. table1 column —— a1 a2 a3 a4 a5 Using the query below, CROSS APPLY will join… Continue Reading →
I recently purchased the Samsung Galaxy SIII from T-Mobile and was unable to clear the icon from the notifications bar. I have my voicemail managed by Google Voice so I first disabled forwarding under Phone > Call Settings > Call… Continue Reading →
A common table expression (CTE) is used in this example to create a temporary result set with a sequential number that allows us to do the arithmetic required to calculate percent change.
To select the columns in a specified table in SQL Server, use this code: SELECT c.name FROM sys.columns c, sys.tables t WHERE t.name = ‘table_name’ AND c.object_id = t.object_id
I recently purchased the EPSON WorkForce Pro GT-S50 Document Scanner on Amazon for $329.98. I was also considering the Fujitsu ScanSnap S1500, and settled with the GT-S50 after reading positive reviews. The most common issue I read with the ScanSnap… Continue Reading →
Very interesting read on how Instagram solved a problem with having a single unique ID across multiple applications. Sharding & IDs at Instagram
The MSDN article on decimal and numeric data types explains that precision in the decimal data type is the: …total number of decimal digits that can be stored, both to the left and to the right of the decimal point.… Continue Reading →