BrainDonor (7/13/2012)

---

Gazareth (7/13/2012)

Is that right? My understanding was that the view is only 'solidified' once an index is created on it, and that

WITH SCHEMABINDING is merely a prerequisite for an...

BrainDonor (7/13/2012)

---

This is a bit of a simplification - but basically a view that does not have SCHEMABINDING is just stored as a definition. When you reference the view the...

Another thing to look at could be indexes - I assume #TEMP here is a stand in for your real table - is it indexed at all?

Hi mate,

Not 100%, but as far as my understanding of compression goes, the data is uncompressed during the process of retrieving it, so a select... into... should be fine, as...

Haaico (7/13/2012)

---

I hate to say it but this is another one of those questions that is not quite clear enough. Is a processor core a logical processor or a processor?

The...

94 and counting!

I'll be impressed if anyone does!

Congratulations Gail!

For some reason, I kinda assumed you already...

Lol, they are, aren't they! :hehe:

Hugo Kornelis (7/3/2012)

---

It's a bit disappointing that nobody has yet commented that the "best" way to deal with the issue is to drop the view, then create a new one...

Jeff Moden (7/2/2012)

---

Thanks guys... I understand why some of us might do such a thing but I really want to know why the OP wants to do it. If...

Hi, I'm guessing a bit, but I think the table you're trying to create the FK on contains some data that violates that FK.

Do the FK you're dropping & the...

Well, I used something like this once to check ~30 instances for any db's that still had the...

Read the question as "with schemabinding", grumble.

Serves me right for not having a coffee yet! :doze:

Curiousier and Curiousier...

Welsh Corgi (6/28/2012)

---

I just checked and none of the CASE Statements are updating all of the records.

Does anyone have an example of a Sercehed CASE Statement used to perform UPDATES.

One...