When you send a query to the server, there’s an order to the steps the server will take to retrieve the data you’re looking for. It’s important to have an understanding on what order those steps are, so you know where to start making changes in order to minimize the time it takes to optimize…
Month: January 2011
Online Profiles Vs Online Resumes
Starting the end of 2008 I started noticing a change in my job search I noticed I was getting a lot of emails informing me “I found your resume online, and I believe you would be a great candidate for this position.” At first I didn’t really think a lot about it, since I had…
Checking for Computed Columns
So I’ve been building an auditing system for my new employer that will help track all the changes to the data. Right now, some changes could be made, and we wouldn’t be able to tell who made the change, or when the change was made. I had an “Ah-ha” moment pretty early on. “Let’s use…
SQL 202-Performance Tuning
Honestly, choosing which level to put this content under was one of the harder decisions I had to make when putting this content together. Before you get into this stuff, You need to understand queries pretty well. You should also have the fundamentals on what an index is, and how to manage them (add, alter,…
Happy New Year
2011 is going to be a big year! I’m getting my certification exams out of the way. I’m heading to PASS Summit 2011. I’m pushing myself harder this year, because I know I can do more. What does this mean for you, my very special reader? More content! I’m pushing for more content in 2011…