OK lets step back a bit here...

If you have a general performance issue , a good starting point is the below articles.

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

See if you can identify the queries / procedures...

You've also got high BACKUPIO and BACKUPBUFFER.

so do you have a general performance issues not just deadlock issues ?

The two BACKUP wait states would imply that you are backing up,...

Whats wrong with the answers you have already been given ?

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=159924

http://www.dbforums.com/ansi-sql/1666008-transform-resultset-vertical-horizontal-view.html

The term 'deadlock' is not unique to SQL. The KB article i referenced stated that the internal processing of ASP can deadlock.

If we were to assume that this is...

Is this even a SQL Server issue ??

Reading here http://support.microsoft.com/kb/821268 doesn't sound like it

Hi , performance tuning is a big big area, first off you need to identify which sql statements/procedures are running 'slow'. Personally, i find that making the assumption that...

This link should help you

http://www.karaszi.com/SQLServer/info_datetime.asp

If you run the code contained in the the functions

CR_OverDueLoaneeInstWise_Rpt

and

CR_RecoveryReceiptWise_Rpt

what does the execution plan look like then ?

As i said above the cost of these as functions is hidden,...

Are the execution plans the same ?

Does a stress test tool such as sqliosim , show the same issues ?

Thanks people 😉

Thats what this forum is for, im big enough to take it on the chin.

Starting again with the performance one, but yes i do agree that there will...

DENSE_RANK is what you need , though you have not specified how to order the currencies.

Dump the results of the table valued functions into temp tables.

The cost associated with the the functions themselves is entirely hidden , it could be 10ms could be 10hrs.

Post the...

Please dont double post

http://www.sqlservercentral.com/Forums/Topic1094766-149-1.aspx

Please see this link

http://www.karaszi.com/SQLServer/info_datetime.asp

Hi ,

You need to use the HAVING clause