So I have this table in my new database that is used as the base table for more than 50% of the queries that are run on my server. It’s our product table. Along with all the basic information about products there’s a column that hold the status of that product, it’s either active or…
Year: 2011
What Does Google Have to Say About You?
It’s 2005 and I just started with GCS. I was just getting to know my team-mates when one of them told me “you really should check your spelling before you publish a page on your website.” I didn’t know how to respond. I asked my soon to be friend to explain what they were talking…
SQL 202-Covered Indexes
By this point you should feel pretty comfortable with what an INDEX is and what it does for your queries. Basically it provides the server to find your data rows more quickly by creating a look-up to find key values. When teaching indexes I usually open the book closest to me, and show them the…
T-SQL Tuesday-Resolutions
The challenge went out to talk about my techie resolutions. I know I’ve discussed this earlier, but in just a week, I’ve made some progress. Certifications My goal is to complete not one MCITP path, but two! I scheduled my first exam for January 10, 1pm EST. Yes, when this post goes live that will…
SQL 202-Theoretical Exection Orders
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…
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…