How to SELECT NON DISTINCT COLUMNS FROM A TABLE.

SELECT [COLUMN]
FROM [TABLE] T1
WHERE (SELECT COUNT(*) FROM [TABLE2] T2 WHERE T1.[COLUMN] = T2.[COLUMN]) > 1

This returns all of the non distinct (opposite of distinct) rows.


SELECT [COLUMN], Count(*)
FROM [TABLE]
GROUP BY [COLUMN]
HAVING COUNT(*) > 1

This returns what is distinct and how many rows there are that has the value.

Diablo 3 Nvidia Surround (3 Monitors) Taskbar Hide.

I was playing Diablo 3 with 3 monitors using Nvidia Surround. I encountered an issue with the windows taskbar being in the way so this is what I did to fix the issue.

1) Go to Nvidia Control Panel.
2) On the Top toolbar next to "Edit" choose "Desktop" then Surround Displays and make sure that "Confine Taskbar to Center Display" is not checked.
3) Go to the normal Windows Task bar right click on it and go to Properties.
4) In the properties check "Auto-Hide Taskbar"
5) Now Launch Diablo 3 with Surround turned on.
6) Make sure Diablo 3 is being ran on Full Windowed Mode.

Enjoy

BACKUP Your Systems/Databases!! - Pixar Story

http://www.myextralife.com/sitenews/backup-your-file-systems-by-pixar/

Cheap, durable backups

While some people have huge disk space requirements for their computers, upwards of 4 Terabytes or for some simpler users less than 2 GB of non-operating system space, my guess is that most are like me and don't have an overly large need for backing up the very most important stuff.  There are many great online-backup options out there and I do personally use SugarSync for 5 GB of free space over other common options like DropBox.  However, my photos, videos, and important documents cannot fit in that space and I feel the annual cost of backing up online or "in the cloud" would be too costly.  I've found an alternative.

I was of the mind to buy an external hard drive and store it in my fire-proof lock-box at the house, and more recently though to maybe use an external or even internal Solid State Disc (that is, flash memory) since it is more durable.  A coworker of mine also suggested using standard USB flash drives instead, and I thought "that's perfect!"

Benefits for usage as a backup device:

• Tiny physical size, easy to store multiple
• Available in large sizes for great prices (32 GB for $16!)
• Very durable (shock resistant, water resistant)
• Good transfer speeds (SATA III speeds not necessary for a once-per-month backup routine)
• If more space is needed in a couple years, you can add or replace for even cheaper

I recommend the deal on Newegg right now through 3/31/12, a 32 GB Voyager (rubberized exterior) for $16 after mail-in-rebate, great price!
http://www.newegg.com/Product/Product.aspx?Item=N82E16820233158

Now I just have to figure out a way to either sync or setup easy manual back-up process...

Execution ' GUID ' not found during SSRS

Running a SQL Server Reporting Services Report and stumbled upon this error for every report.

Execution ' GUID ' not found

This is how I fixed it.

Created a Text file and named it sessionTimeout.rss

Public Sub Main() Dim props() as [Property] props = new [Property] () { new [Property](), new [Property]() } props(0).Name = "SessionTimeout" props(0).Value = timeout props(1).Name = "SessionAccessTimeout" props(1).Value = timeout rs.SetSystemProperties(props) End Sub

Save the file to the C:.

Then Run this command in command prompt:

rs -i sessionTimeout.rss -s http://localhost/reportserver -v timeout="6000"

(You might need to change the url if you did not keep it defaulted).

Your reports should now run.

Script to delete everything in all tables in database.

select

'Delete from ' + convert(varchar(max),name)

from sys.tables

Great Site for SSRS Inormation

Here is a site that I used to determine how many times a specific report was ran.