And to return a distinct record for each combination of values without pulling an ID.

SELECT DISTINCT age, height, gender FROM persontable

I know GilaMonster has a more correct answer but...

Check this...MSSQL Net-Library Encryption using SSL

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_cs_6fu6.asp

IMHO, I would definately want to understand the errors depending on the severity. Warnings are basically what level you are comfortable with.

Here is some advice on some typical scenarios:

http://www.sqlservercentral.com/columnists/bahmed/backupscenariosforsuccessfulsqlserverrestoresandre.asp

Maybe the Management / Current Activity / Process Info / Memory Usage column would show you old connections that are using up query memery?

Good point David. I missed that and after trying the clause I found the query is fast when adding the seemingly trivial AND shiftdate < GETDATE. So this had nothing...