SQLServer

SQL Server Tipping Games – Why Non-Clustered Indexes are just ignored!

Almost everytime when I’m doing SQL Server consulting engagements, DBAs are showing me queries and their Execution Plans, where SQL Server is just ignoring a good defined Non-Clustered Index. Imagine for example the following table and index definition: CREATE TABLE Customers ( CustomerID INT NOT NULL, CustomerName CHAR(100) NOT NULL, CustomerAddress CHAR(100) NOT NULL, Comments …

SQL Server Tipping Games – Why Non-Clustered Indexes are just ignored! + read more

My 2 cents on SQL Server 2014

Yesterday during the opening keynote of TechEd North America Microsoft released the first official details about the next version of SQL Server: SQL Server 2014. There are huge improvements in the area of High Availability, Performance, and Scalability, on which I want to concentrate in this weblog posting. Disclamer: This blog posting is based on …

My 2 cents on SQL Server 2014 + read more

Become an expert in SQL Server Performance Tuning & Troubleshooting!

Since September 2012 I’m a Microsoft Certified Master SQL Server 2008, which is the highest technical certification for SQL Server that is currently available. Because I want to share my performance tuning & troubleshooting knowledge, and because of the huge demand on performance tuning I’m running again this year my popular SQL Server Performance Tuning …

Become an expert in SQL Server Performance Tuning & Troubleshooting! + read more