I try to write slow, for those who cannot read fast

Seriously, today has been one of the few...

- Good point Jeff

- Also check what kind of transaction isolation level is used for the connection and / or command ! And...

No problem, just add the highlighted 

;with cteMPVAliasByRank (Ranking, Alias, Country, Yearmonth, PrizeAmount)

as

indeed, that's a little confusing flaw in my code part.

As you can see my first code post, I'd updated it before you replied....

btw the most common use of CTE's is as a replacement for nested table expressions.

In many cases in join operations, CTE's will outperform repeated nested table expressions.

Check BOL or SSC

Can CTE's be used within a Stored Procedure?

Yes they can !

CTE's are new with Tsql in SQL2005. Search BOL or SSC  for more...

So this is on SQL2005 ?

Try this new CTE :

-- replaced your persistent table to #temptb just for testing

create

table #tblMPVLeaderBoard(

LeaderBoardID int,

Yearmonth...

- Check that the @SITEID is defined exactly as is your column SiteFK in your table Clients. This way you avoid implicit conversions, which may cause your index not being...

With your top-clause, sqlserver ends the search for rows when the top-number is reached.

So if the top-number hasn't been reached, the quest goes on !

Because your plan shows...

Keep in mind it is not needed for SQLServer to have a domainadmin privileged service account !! (Huge risk !!)

Keep in mind it is not needed for SQLServer to have...

- yes

- read the (inside) books, play, test

- test, test, test, play

- follow some good forums like SSC

learn to play, play to learn

And if you...

I second that, GilaMonster  !

You may be better of putting some effort into analysing top-x predicate combinations and providing good accesspaths for...

especialy on production boxes, you may want to avoid haven autoclose active !

This way sqlserver will keep the database open and you'll avoid the time consuming open action for your...

IMHO your "quotable" datatype is a user defined datatype

Easyest way to find out is to use Enterprise Manager, connect to the database and...

- can you see anything in the sqlserver errorlog file(s) when you reboot the server ?

- or in the errorlog.1 file if you start it manualy ?

- Are there any...