SQL Server Quickie #13 – Hash Join Operator
Today I have uploaded the 13th SQL Server Quickie to YouTube. This time I’m talking about the Hash Join Join Operator in SQL Server. Thanks for watching! -Klaus
SQLServer
A ever-increasing Clustered Key value doesn’t scale!
You know all the best practices how to choose a Clustered Key value? A good Clustered Key value should have the following 3 properties: Narrow Static Ever Increasing Let’s have a more detailed look on all 3 properties, and why an ever increasing value doesn’t really scale in SQL Server. Narrow A Clustered Key value …
A ever-increasing Clustered Key value doesn’t scale! + read more
Improving Query Performance by using correct Search Arguments
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
Goodbye SQL Server, Hello FileMaker…
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 …
SQL Server Quickie #12 – Nested Loop Operator
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
