Two thumbs up, Gianluca.

[edited]

had a Dypo in the 3 words...

Jeff Moden (8/5/2011)

---

Leo.Miller (8/2/2011)

---

Jeff Moden (8/2/2011)

---

Leo.Miller (8/1/2011)

---

I can't see any real benefit of using an iTVF, since as far as I can see, [font="Arial Black"]you can still only pass it...

Koen Verbeeck (8/4/2011)

---

Fal (8/3/2011)

---

Koen Verbeeck (8/3/2011)

If you do try a Belgian beer once more, try one of the trappisten.

And make sure it is server as it should be server, it...

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