In today’s blog posting I want to talk about a very specific performance problem related to indexing in SQL Server. The Problem Imagine the following simple query, which you have already seen hundreds of times in your SQL Server life: — Results in an Index Scan SELECT * FROM Sales.SalesOrderHeader WHERE YEAR(OrderDate) = 2005 AND …
Improving Query Performance by using correct Search Arguments + read more
The last weeks were very time consuming for me, because I had to make a very tough decision: staying independent and providing high quality SQL Server consulting and training services, or getting employed (again), and being part of a greater team to influence how the IT industry will be in future. After a very long …
Today I have uploaded the 12th SQL Server Quickie to YouTube. This time I’m talking about the Nested Loop Join Operator in SQL Server. Thanks for watching! -Klaus
In todays blog posting I want to concentrate in more details on the Updateable Clustered ColumnStore Index that is introduced with SQL Server 2014. Before we go down to the details, I want to give you a brief overview about their first appearance in SQL Server 2012, and their limitations. ColumnStore Indexes in SQL Server …
The Illusion of Updateable Clustered ColumnStore Indexes + read more
SQL Server 2014 will be an amazing release regarding all the various performance enhancements that are part of this new release. Over the last months I have already done a huge amount of work and tests on the latest CTP version of SQL Server 2014, and I have already blogged about my experience. In this …
Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.
