search ssc for "lost sa password". Those threads will get you started.

e.g. http://www.sqlservercentral.com/Forums/Topic1054427-146-1.aspx

As I got to understand it, an itvf can be fully bound and taken into account at plan compile time.

That may provide more intelligent solutions then we might expect and...

why the hassle with cu3 and 4 before going to SP1 ??

SP1 = CU6+ ssms intellisence fix (bug after vs2010SP1) and maybe some more.

if I'm correct : SP1+SP1CU1 = RTM+CU8

I...

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...