CXPACKET just means you have parallelism.  It doesn't on its own mean you have a problem with parallelism.  Please don't blindly reduce parallelism just for the sake of it.  How...

It may, or it may not.  But if the query covers data that isn't uniformly distributed (lots more Johns than Jims), you're likely to see parameter sniffing.  Setting optimize for...

No.  If you're getting the plans by querying the DMVs for the plan cache, those don't have the actuals in them at all.  They never do.  They're compiled when the...

The easiest conclusion to draw is that you had a poor plan for the query you were running.  Once you cleared the cache, the query recompiled with a better plan...

WITH Numbered AS (
    SELECT
         FieldSort1
    ,    FieldSort2
    ,    FieldSort3
    ,    ROW_NUMBER() OVER (PARTITION BY FieldSort1 ORDER BY FieldSort2, FieldSort3) AS RowNo
    FROM #TimeIncrements
    )
SELECT
 ...

Arshad

The plans that are stored in cache are plans that are used for all executions of a particular query until the plan is evicted from cache.  That's why...

You've posted in the SQL Server 2008 forum.  Is that actually what you're using?

John

Type "algorithm that SQL server uses to determine the RANGE_HI_KEY" into your favourite search engine.  That's what I did, and the second result looked as if it might contain something...

Brandie

Why not create a new variable called @DayNumTarget, set the value of that in your config file, and change the constraint to (@DayNum == DayNumTarget)?

John

You're getting the error because you're trying to force a result set into a scalar data type.  Result sets can only be fed into a variable with data type Object....

I think Thom has already answered your question.  But I'm not sure what the purpose of your stored procedures are, especially the first one.  It sets the value of a...

Tom

I've never needed to do anything like that.  But I imagine there's a registry key somewhere that determines how many recently used servers to remember in the Connect...