20Aug 2012 by Grant Fritchey 2 Comments

Another Execution Plan… In the Cloud!

Azure
A couple of weeks ago I posted about how different execution plans look when using the Azure Management Portal. I promised to look at a more complex plan and here we are. The query looks like this: SELECT * FROM dbo.Agent AS a JOIN dbo.Resource AS r ON a.AgentId = r.AgentId JOIN dbo.MovieStageResource AS msr ON r.ResourceId = msr.ResourceId JOIN dbo.MovieStage AS ms ON msr.Movieid = ms.MovieID AND msr.MovieStageDefinitionId = ms.MovieStageDefinitionId JOIN dbo.Movie AS m ON ms.MovieID = m.MovieId WHERE a.AgentId = 42; I didn't go nuts in creating a crazy complex query. I just wanted to see a standard set of different operators to see how things changed. As before, I'm working off a controlled database that has identical structures and data in both the Azure database and my…
Read More
16Aug 2012 by Grant Fritchey 3 Comments

Coming to Your Town

PASS, Professional Development
I can't sing and I can't play and I left the young generation behind a while ago, but I'm still coming to your town, or maybe one near you. Between August and December I'm hitting a substantial portion of the country, so if you want to have a little fun, discuss SQL Server, network, or just chat, here are your chances. Please, ask me questions. Please, walk right up and say hello because we can learn from each other and I love my SQL Family. Here's where I'm going to be: SQL Saturday #125 in Oklahoma City, August 25: Only one presentation here, Top Tips for T-SQL Performance, but it's a fun presentation. Register now because time is running out. SQL Saturday #156 in Providence, RI, September 15: This is…
Read More
19Jun 2012 by Grant Fritchey 2 Comments

PASS Summit 2012

PASS
I sure hope you’re planning on attending the PASS Summit this year. If you’re not, you might want to reconsider. They’ve just released the list of sessions. You should click this link and check them out. There’s going to be some magnificent instruction available in all aspects of SQL Server. You don’t want to miss it. On a personal note, I’m doing an all-day pre-conference seminar on query performance tuning. It’s called “Query Performance Tuning: Start to Finish.” The pre-con’s, as we call them, are an additional cost on top of the cost of the Summit itself. But you’re flying out to Seattle anyway. Why not attend a full day of learning, walk away with a little more knowledge under your belt. I’m going to give you as much information…
Read More