You asked:

This is the only subquery I see:

...

I will have to do some research, but the developer is full of it when it comes to needing to have to use sa to create temp tables.

I'll let you...

Full Backup - Everything is backed up.

Differential Backup - Everything that has changed since the last Full Backup is backed up.

Incremental Backup - Everything since the last Incremental Backup is...

What exactly is the error you get?

Have to comment on the snow. I live in Widefield (or as my parents like to say, North Pueblo), and we get very little snow on average when compared...

Jack Corbett (9/30/2008)

---

Sorry, my question was meant to be funny. I do know what BI is,...

Some sample data, a table for the sample data, and the expected output would help greatly. Preferable, all of this should be done such that all we have to...

Actually, to be precise, it...

mixalissen (9/30/2008)

---

UPDATE t

SET count_Successful_modulesOfProgram = CountModulesOfProgram

FROM @tmp t,

(

SELECTcert_cand_programs.candidate_fk,

COUNT(cert_cand_programs_fk) AS CountModulesOfProgram

FROM cert_cand_programs

INNER JOIN cert_cand_programs_details ON cert_cand_programs.pk = cert_cand_programs_details.cert_cand_programs_fk

INNER JOIN Exam_Candidate...

dfine (9/30/2008)

---

Hi,

I don't think you can disable the idnex.

instead you can drop and re create it.

If your table contains huge no of records with clustered index created

then re creating...

Actually, that's one of the reasons they state in BOL for disabling an index. Go to books on line and check out ALTER INDEX.

😎

I agree with what Chris said for the most part. Based on what you said in your original post, I would put the clustered index on the datetime +...

My first question is why do you need to disable the index?

😎

sblock (9/30/2008)

---

A side question. I know that when you reboot, tempdb is rebuilt based upon the model database (privileges, etc.). Is the initial size of tempdb based upon...

Is it better to scrap the plan rather than make the change and see what breaks then fix it?

😎