Jeffrey Williams (4/15/2009)

---

Okay - I am just wondering if Lynn has finally hit his limit. I'm just a bit surprised - and shocked - and the response :w00t:

http://www.sqlservercentral.com/Forums/Topic697843-146-1.aspx#bm697863

Really -...

Did you update statistics after the upgrade?

There's no need to bump your post after just a few hours. This is not a chat room, also some people are away due...

Did you update all statistics after the upgrade?

For composite...

Maybe. Could you show a few sample queries? (use profiler/SQL Trace to get a sample workload if you don't already have one)

Is there any combination of columns that's frequently filtered on?

It depends on the reason that the DB is suspect. Please have a look at the SQL error logs for any errors that refer to that database. Post them here.

Do...

Then check other jobs that run at the same time. I don't know if it's possible to have custom scripts in a maint plan, if so check them. SQL won't...

I love it when people are dead wrong with complete confidence.

Chris Morris (4/15/2009)

---

Are you...

Is this an existing app, or one in planning?

If it's existing, I would suggest you trace the server for a couple hours and see what the most common queries are,...

Probably because somewhere in the backup job there's code that switches the recovery model to simple and back to full. SQL won't just change the recovery model by itself. If...

Maybe I'm missing something, but why is it a concern which it is? If you know the material, case study or no case study shouldn't matter.

No. Points here are purely from posting and from answering the Question of the Day.

Can you at least post the DDL for Request and Request type, including indexes, and the query in question?

By the looks of the screen shots this is a SQL 2000...

samartel (4/15/2009)

---

I am also going to write 433. With the study guide not out from Microsoft yet, and no practice exam to try, could someone give me a hint...