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 3 of 3   

Execution Plan reuse

By Steve Jones 2014/12/17 | Category: performance
Rating: (not yet rated) |  Discuss |   Briefcase | 1,854 reads

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: | Category: execution plans
Rating: |  Discuss |   Briefcase | 8,593 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: | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 706 reads
   Items 1 to 3 of 3   
administration (1)    
blogs (1)    
hash match (1)    
parallelism (1)    
t-sql (1)