Welcome in Dinesh Patel Blog

http://www.reckeweg-india.com/

DECLARE  @Country  VARCHAR ( 20 )  SET  @Country  =  'US'     SELECT  *      FROM  Sales.SalesOrderHeader h ,  Sales.Customer c ,           Sales.SalesTerritory t      WHERE  h.CustomerID  =  c.CustomerID          AND  c.TerritoryID  =  t.TerritoryID          AND  CountryRegionCode  =  @Country     OPTION  ( OPTIMIZE  FOR  ( @Country  =  'US' ))

Clear the procedure cache between runs you can use the DBCC FREEPROCCACHE command

Link:  http://www.mssqltips.com/tip.asp?tip=1429

Link:  http://www.mssqltips.com/tip.asp?tip=1474&ctc  

http://demos7.dundas.com/Sonatica.aspx  

WITH MEMBER [Direct] AS (([dimExpenseDimension].[Direct Indirect].&[1]&[1], [Measures].[YTD Expense Sum]) / [Measures].[YTD Gross Earned Premium]) MEMBER [Regional Office Recharges] AS (([dimExpenseDimension].[Major Expenses].&[1]&[2]&[6], [Measures].[YTD Expense Sum]) / [Measures].[YTD Gross Earned Premium]) MEMBER [Platform Recharge] AS (([dimExpenseDimension].[Major Expenses].&[1]&[2]&[5], [Measures].[YTD Expense Sum]) / [Measures].[YTD Gross Earned Premium]) select {[Direct],[Regional Office Recharges],[Platform Recharge]} on columns , [dimLocationDimension].[Country]. CHILDREN on rows from [cubeExpenseFact] where ([dimTimeDimension].[Month Wise].[Month].&[2009]&[12])