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

Scripts by Gulli Meel

SQLServerCentral.com profile

   Items 1 to 5 of 5   
 

Issue with Current Merge Join algorithm and ways to Improve it

This will show you the issue with current Merge join algorithm and a workaround for this and thus improving the performance of Merge joins  Read more...
Rating: (not yet rated) |  Discuss |   Briefcase | 1,057 reads

Finding Top N worst performaing queries

This is one another way to find queries performing badly  Read more...
Rating: |  Discuss |   Briefcase | 4,107 reads

Use your own optimizer to tune queries

Use your own optimizer to tune queries  Read more...
By Gulli Meel 2012/06/07 | Source: SQLServerCentral.com | Category: custome statistics
Rating: |  Discuss |   Briefcase | 2,748 reads

New Analytical Methods using Partition Vs. old Style Methods

This will give you different methods to find the orders details for which has more than 5 differnt products.  Read more...
By Gulli Meel 2012/05/31 | Source: SQLServerCentral.com | Category: analytical methods
Rating: (not yet rated) |  Discuss |   Briefcase | 654 reads
   Items 1 to 5 of 5