Oh, I bet there's more than 5% still to be gained with that query. But that's not my call.

e.g. one of the first optimisations i did by altering a svf to an itfv resulted in:

before: duration +/-4000ms

after: duration +/- 328ms

This was for a single query that was run...

No.

You'll have to provide enough disk space (=size of the original db files) to be able to perform the restore.

After that you can shrink files, but keep in mind...

If my perception on the matter is ok running a db in a lower db level than the engine:

- may not produce the same results, sqlplans, .... as with the...

I'm sorry it didn't help out :blush: Very rare at SSC 😉

Thank you for posting the feedback of the solution that worked for you !:Wow:

I have a cell phone because I'm on call ... if it weren't for that, I wouldn't have one at all.

Company takes care of 20€ / month leaving me a...

Then I see no issue(s) on having it in 90 mode for a transition time span 😉

Keep in mind to keep a backup of your SQL2005 db created from a...

we tend to prep our backup jobs to have a last step to copy the .bak files to a safe zone.

Restores towards test servers are being performed using these safe...

I hope you did run the upgrade adviser tool. It will point to potential issues and may be a great to prevent failures and prepare migration projects.

Don't start without it...

how about:

if exists (SELECT 1

FROM [Annual_Edu_2006].[dbo].[HREMP_Adp]

Where [LName]+', '+[FName] = @username

and convert(VARCHAR(10),DOB,101) = @DOB )

return 1

else

return 0

some drop'm after a restore. I don't advise it, but it happens.

BEFORE going for any harsh action I would investigate the issue.

What else is failing, causing issues to that sqlinstance at that time ?

(IO subsystem notifications, other db having alike issues,...

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