The SQL Server Interview Questions that Matter
feb 23,
2018
If you’re worried about interviewing for a SQL Server job, here’s some advice from the former head of an IT department on what matters (along with examples from the three critical areas where you need to have answers ready). As an instructor for Learning Tree’s Querying SQL Server 2014 and 2016 courses, I’ve worked with […]
Tools to Aid your SQL Server Plan Cache
aug 22,
2017
In a recent blog post, we looked at how SQL Server uses its index statistics to help determine an optimal query plan. We will soon look at several examples of the interaction between query plans and the plan cache, but before we do we must develop a set of tools to aid the effort. SQL […]
Optimize SQL Server Queries with Index Statistics
aug 15,
2017
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 […]