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?

😎

We had a performance issue with our migration of PeopleSoft Finance from SQL 2000 to SQL 2005. After months of band-aids and bailing wire, out PeopleSoft Administrator found out...

Wouldn't hurt to fire up Activity Monitor and see if the rebuild is blocked.

😎

This was also the subject of QotD by Sergiy.

😎

Adi Cohn (9/25/2008)

---

I think that today’s question wasn’t a good one. Since the answer is number of 8KB pages there was no correct choice given to us. Bytes...

Awesome on SQL 2008 getting it back! I haven't had the pleasure yet of working with 2008 as I am still waiting to be able to purchase the Developers...

It went away. Do to that now you need, at a minimum, Visual Studio 2005 Professional Edition (Standard Edition isn't good enough).

😎

Have to ask, what type of updates are you talking about, hot fixes and service packs, or data updates?

😎

Also, the possibility exists that data is present when the IF part is processed, but deleted from the table prior to the insert.

😎

jcrawf02 (9/24/2008)

---

thanks Lynn, I knew there had to be a better way. 🙂

Why does that make a difference though? converting from datetime to varchar is implicit; converting from varchar to...

The code could also be written this way:

create table #TestTab (

ADate varchar(10) null

);

insert into #TestTab

select '3/9/2008' union all

select '3/9/2008' union all

select null union all

select '10/1/2008' union...

Actually, I did a little more testing, and here is my code. The null value stayed null, no problems with the update.

create table #TestTab (

ADate...