did you run the upgrade adviser ? It will point to potential issues.

You should be able to just restore the database(s) in stead of a having to port all data.

(unless...

alter your function to be an inline table value function. That may do magic !

create itfv_x

returns table

as return (select your_case_statement as Et_Voila)

keep in mind you'll have to modify your query...

set statistics time will show compile time and execution time of the query, just to give you a look on consumption.

btw did you notice

...

If the errorlog doesn't bring any refs to your issue, I think best is to start a trace which also captures oledb errors and run your app until the issue...

I did like the free ebook "SQL Server Statistics" available at red-gate ebook store. http://www.red-gate.com/our-company/about/book-store/

opc.three (8/1/2011)

---

All valid points I agree with 100% except for the last two words. All things being the way we want them, agred 100%, but "it depends" is...

apparently you are living in a world where users have a fixed UI date time representation.

( so far for "personal" computer )

Alter these queries so you don't need the function...

How about Tetris from time to time :hehe:

is there a query exception recorded in e.g. errorlog ( deadlock / error with Severity levels from 20 through 25 are considered fatal. If a fatal severity level is encountered,...

So, where/how does it keep track if stats are no longer being used ??

SELECT quotename(object_schema_name(OBJECT_ID)) + '.' + quotename(object_name(OBJECT_ID)) as ObjectName

, quotename(name) AS...

According to plan explorer it is this cursor that is estimated to consume 25% of io cost estimate

Declare c1 Cursor For

Select Distinct BD.RegnNo, DD.CaseNo

From Bill_Detail BD, DailyCase_Det DD

Where...

ananda.murugesan (8/1/2011)

---

Thanks for reply... this is very usefull script for identified execution plan on graphical style. once again thanks.

Here i have attached execution plan for xml query plan, please find...

side note on DBCC DBREINDEX in books online :

Important:

This feature will be removed in the next version of Microsoft SQL Server. Avoid using this feature in new development...

my car consumes 9L/100km.

Is that good ?

Maybe, maybe not.

That depends on the kind of car, track, payload,...

What I mean is, without the query, table structure, available indexes, number of rows...

GilaMonster (7/31/2011)

---

Major kudos to the Win 7 developers. Replaced the motherboard, processor and memory of my desktop and when I switched it on, windows booted straight to the desktop, no...