Joseph Michael Pesch
VP Programming

Compare Two Tables in SQL Server

by 21. October 2009 16:26

Code excerpt from: http://weblogs.sqlteam.com/jeffs/archive/2004/11/10/2737.aspx

 

 

 

SELECT MIN(TableName) as TableName, ID, COL1, COL2, COL3 ...

FROM

(

  SELECT 'Table A' as TableName, A.ID, A.COL1, A.COL2, A.COL3, ...

  FROM A

  UNION ALL

  SELECT 'Table B' as TableName, B.ID, B.COL1, B.COl2, B.COL3, ...

  FROM B

) tmp

GROUP BY ID, COL1, COL2, COL3 ...

HAVING COUNT(*) = 1

ORDER BY ID

Tags: ,

SQL Server

Rounded Corners In Photoshop

by 7. October 2009 23:55

1) Draw new layer with the "Rounded Rectangle Tool" (radius of 25px is usually pretty good for corners).

2) On the new layer that you just drew the rounded corners on select the "Paths" tab and then click the little right-arrow to get the drop-down menu, from that menu select "Make Selection" (make sure the "Feather Radius" is 0 and the "Anti-aliased" is checked).

3) Edit > Copy (or CTRL+C)

4) File > New ("Background Contents" = "Transparent")

5) Edit > Paste (or CTRL+V)

 

Tags: ,

[None]

Turn Off Windows Hibernation

by 1. October 2009 19:20

Delete hiberfil.sys in Vista

Here’s a way to turn off hibernation and free up a couple of gigs on your system drive…

Click Start, All Programs, Accessories, right click on “Command Prompt”, and then click “Run as Administrator”. If User Account Control (UAC) asks you for permission, permit the Command Prompt to run.

Next, type “powercfg -h off” (without the quotes), followed by pressing Enter.

Close the Command Prompt window and restart.

Original post from: http://www.abxzone.com/forums/f109/delete-hiberfil-sys-vista-105337.html

Tags: ,

Vista