The 1st half of 2013 is almost over, so it’s time to announce my upcoming SQL Server trainings for the rest of 2013. Besides my traditional SQL Server Performance Tuning & Troubleshooting Workshop I have added 2 brand new workshops into the schedule: DBA Essential Days Without a Trace – Extended Events in SQL Server …
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
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 …
Today is a very sad day for me. My love, my dear Windows has passed away. We were together for over 20 years, her illness took control over her, and during the last days she passed away. Before I give you further details about the disease she had over the last year, I want to …
Every one of us knows Bookmark Lookups in SQL Server. They are great, because you don’t need to care about your indexing strategy. They are bad, because with Bookmark Lookup you just introduce a bunch of other problems for your SQL Server installation. Almost every time when I’m on client side for consulting gigs, I …
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.
