“Hot town, summer in the city. Back of my neck getting dirty and gritty. Been down, isn’t it a pity. Doesn’t seem to be a shadow in the city. All around, people looking half dead…” It’s hot, very hot here in Vienna! For me it’s always time to cool down (from work!), relax, and work …
Today I have uploaded SQL Server Quickie #37 to YouTube. This time I’m talking about Inner Joins in SQL Server. Thanks for your time, -Klaus
When I talk about indexes, people always ask me if the sorting order of the columns in a composite Non-Clustered Index matters? The short answer is always “It depends”. Let’s have a look on it why “it depends”.. Singleton Lookups When you have queries which perform Singleton Lookups on your tables, the sorting order of …
Composite Non-Clustered Indexes – does the Column Order matter? + read more
Every index in SQL Server can improve your query performance, if the Query Optimizer chooses the index in the execution plan for data retrieval. But on the other hand every index will also hurt your performance, because the index has to be maintained during INSERT, UPDATE, and DELETE operations. Therefore it is very important to …
999 Non-Clustered Indexes on a Table – a good idea? + read more
As you might know, Microsoft announced a few weeks ago that they will release a fully working SQL Server product on Linux! If you want to see how SQL Server on Linux works, and how it feels to run queries against it, please checkout the following video, which was published 2 weeks ago on Channel …
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.
