Subqueries, Real and Apparent

Part II – The Table Spool In the previous installment, we looked at a very simple logical subquery that SQL Server executed as a physical join. We shall now take a look at a somewhat more complicated query and see what SQL Server does with it. In this query, we would like to get a […]
Read More ›

Subqueries, Real and Apparent

As a part of our continuing study of SQL Server query plans, we’re going to take a look at some subqueries. This is particularly important, since subqueries are the subject of some fair amount of folklore, and it is important to separate fact from myth. It’s not uncommon to hear someone say “Joins are better […]
Read More ›

Optimize SQL Server Queries with Index Statistics

Television’s Mythbusters seem to have a lot of fun; it’s interesting that so many myths seem to involve blowing stuff up on camera. SQL myth-busting may not be as visually dramatic, but for people who are interested in query performance, it is much more important. There are a lot of people who think that it […]
Read More ›

Missing Server Configuration Manager from SSRS Server

I had an interesting problem recently. I was doing some work for a client on a CRM deployment and a performance issue. Whilst onsite, I helped with a problem with SSRS and reports not displaying. Further investigation displayed an error that said SSRS was not using a valid execution account. The error was “The report […]
Read More ›

How Much do SQL Server Data Professionals Make?

You’ve thought about your career, you can’t make up your mind about which direction you want to take it. You want to make an informed decision and work out if the career you chose will provide you with financial security you need. The good people at brentozar.com have been running a salary survey and the […]
Read More ›

Type to search blog.learningtree.com

Do you mean "" ?

Sorry, no results were found for your query.

Please check your spelling and try your search again.