Pretty Good question! I liked it. Shows off some of the new enhancements in SQL2008...:-)

Steve Jones - Editor (8/23/2009)

---

Interesting approaches. I still think that having a non-RAID, drivespace like protection makes good sense for home, especially as it can be hard to find drives...

pgolds (8/21/2009)

---

I've been using Mozy for several years now and it's been great. It's configured to back up all my data and it backs up automatically when the computer...

Ben Moorhouse (8/21/2009)

---

I'm thinking I need to do some kind of off-site stuff, but it will just be things like photos and written data (the stuff which can't just be...

Steve,

I'm paranoid about losing stuff. I have RAID (mirroring) on my home pc, a NAS device I use for backup and filesharing and external drives I use for backups....

rja.carnegie (8/20/2009)

---

I was on that in another discussion. It...

Steve Jones - Editor (8/20/2009)

---

I tend to agree with Jason here. What you do on your time off, really isn't the business of your employer, provided you are not representing...

Probably should use SET vs. SELECT. Think I saw that as being deprecated, but I might be wrong?

Mike in Michigan (8/19/2009)

---

I can just picture companies deliberately bringing in people for a few days at low wages and no benefits and doing it over and over and over...

Actually, you could do an implicit or explicit conversion....

'implicit'

SET @DateTimeVariable = @CharVariableContainingDateString

vs.

'explicit'

SET @DateTimeVariable = convert(datetime,@CharVariableContainingDateString)

Interesting concept!

I don't think I'd drop a fulltime gig to go to a 1 week contract, but most companies have at lease some sort of probationary period. But it...

Pretty interesting approach! This seems like it would work smoothly.

Did you run into any snags along the way?

Andy DBA (8/10/2009)

---

GilaMonster (8/10/2009)

---

The equivalent query using exists is this:

SELECT * FROM employee WHERE NOT EXISTS (SELECT 1 FROM emp_detail where employee.emp_no = emp_detail.emp_no)

That will probably run much the same...

rja.carnegie (8/10/2009)

---

gregory.anderson (8/10/2009)

---

Grasshopper, by the way, I'm not putting them in master.....just using a dbname as an example (obviously a bad example).

Thanks for your response, but I'm having a little...

I think you missed a very important point I try to stress to all my developers (unless I missed it in the list), and thats to review your query plan...