sql202
SQL 202-Interpreting your Execution Plan
OK, I've explained how you can see the execution plan for your query (either the actual or the estimated). So now you can see your plan...Now what? What do you
Latest
sql202
SQL 202-Indexes with WHERE clauses
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
Leasing Time Again: How Azure Made Me Think of Mainframes
The first time I logged into the Azure Management Portal in early 2011 and spun up a SQL Azure instance, I had a strange feeling of déjà vu — despite being about two decades too young to have lived through the original. I was leasing time on someone else's
career development
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
sql202
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
personal
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
sql202
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
career development
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
SQL302
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
sql202
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
personal
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
product reviews
Product Review: DTS xChange
Late last week I was informed our new servers would be available January 3, and I should be ready to set up my new SQL 2008R2 two-node cluster. I can't begin to