Here is a great webpage that any SQL developer should read once in a while. It is a refresher course on some of the things you might have learned in college but forgot. sometimes we get in the habit of coding a certain way and get lazy
Tonight I was doing a little coding (girlfriend and I had a huge fight so I went back to the office) I just happened to change a couple things in the where clause around and noticed that the speed was improved. Since I was amazed and confused at the same time. My ADHD got the best of me and I quickly ignored my script I needed to write before tommorrow morning and spent the next 2 hours of my life solving this little puzzle.