Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags Performance, Execution Plans Rss

   Items 1 to 2 of 2   
 

Join Operations – Hash Match

The way in which SQL Server chooses to join your tables in a query can dramatically affect performance. In this article, Jason Brimhall explains how a hash match works and shows some performance numbers.  Read more...
By Jason Brimhall 2014/03/04 | Source: SQLServerCentral.com | Category: execution plans
Rating: |  Discuss |   Briefcase | 8,345 reads

Nested Loops, Parallelism and Confusion

I’m 30 today. In addition, it’s been 10 years since I started working with SQL Server. In my twenties, I fell in...  Read more...
By Matan_Yungman 2013/06/11 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 453 reads
   Items 1 to 2 of 2   
 
Tags
blogs (1)    
hash match (1)    
parallelism (1)    
t-sql (1)