I was in your position about a year and a half ago. There have been some great tips so far. One tip I would suggest is keep some...

You can use the EXCEPT operator like this:

(SELECT * FROM A

EXCEPT

SELECT * FROM B)

UNION

(SELECT * FROM B

EXCEPT

SELECT * FROM A)

I've worked as a summer school teacher, after-school tutor, janitor, teacher's assistant, and armored transport guard/driver. I got a job in IT as a data analyst, and I'm slowly...

Flashmob

One book I recommend: http://www.sqlservercentral.com/articles/books/67441/

It's not really a technical SQL Server book, but it's a great free book that gives advice on mindset, training, etc.