I don't believe anything is missing... just alter the column like I did... don't mess with the constraint or the default.

karthikeyan (5/30/2008)

---

Also , i have some questions on TempDB.

1) what is the best size of TempDB ? The answer may be 'it depends',But if anybody added some valid points then...

Matt Miller (5/30/2008)

---

bcronce (5/30/2008)

---

when you do a (select * into #table), doesn't it lock the tempdb the entire time of the select staments because the tempdb is locked during the...

Look at the code, guys... column was previously defined as NOT NULL.

Dunno if it'll work because no one provided the code for the rest of the table, but...

I'd say to never look at the percentage of batch in the execution plan... it lies... a lot...

First, I think I'd use UNION ALL... considering the source tables, there's probably not much chance of duplication, anyway.

The other thing is that the CPU time is not varying all...

Tomm,

Your code won't work on SQL Server 2000 (this forum is a 2k forum)... keyword PERSISTED does not exist and the calculated column is considered "non-deterministic" in 2k so the...

Heh... regular doses of a good Scotch and soda fixed mine... 😛

jmapledoram (5/30/2008)

---

But correct me if I'm wrong, doesn't a Table Variable get stored in ram rather than the tempdb? You will want to consult your DBA before writting a lot...

Thanks for the feedback, David!

Welcome aboard, Steve! And thanks for the feedback!

OP is passing in Varbinary... I guess I don't understand... what does the input actually look like and what should the output be?

Are you suggesting that the input is in...

Nightstick recalibration or just a crushing blow to the calcium knob?

Thanks for the feedback, Bob. Yeah, it's sometimes very difficult to simply ignore such a post... but I should get better at just blowing those types of posts off...

Thanks...

It is, but not if you use it in a single select against a multi-row table to try to generate more...