SQL Clone
SQLServerCentral is supported by Redgate
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,089 reads

Finding Top N worst performaing queries

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

Use your own optimizer to tune queries

Use your own optimizer to tune queries 
By Gulli Meel 2012/06/07 | Source: SQLServerCentral.com | Category: custome statistics
Rating: |  Discuss |   Briefcase | 2,867 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 | 669 reads
   Items 1 to 5 of 5