I'll start by checking "Forum" user default schema.

sani (12/7/2010)

---

I am asking how to implement Test server so that DBA can test scripts which are provided by developer before applying in Production Server. How to maintain this environment...

vinothraj (12/6/2010)

---

Questions

1) Instead of having Default value on column, insert explicitly default value.

2) Keep column constraint as NULL(Eventhough it ll not have NULL at any time) & explicitly take care...

Thank you Gail.

I got the Null constraint, what you say makes sense.

In regards to Check constraint, still not sure how can a check contraint have an impact on execution plan...

Jeff Moden (12/4/2010)

---

PaulB-TheOneAndOnly (12/4/2010)

---

Jeff Moden (12/4/2010)

---

PaulB-TheOneAndOnly (12/4/2010)

---

Jeff - I'm not saying you should not use a clustered index, I'm saying you should use it when it brings some value.

I've seen...

Brigadur (12/4/2010)

---

PaulB-TheOneAndOnly (12/4/2010)

---

GilaMonster (12/4/2010)

---

Check and not null constraints can...

mmmhhh... Please...

Jeff Moden (12/4/2010)

---

PaulB-TheOneAndOnly (12/4/2010)

---

Jeff - I'm not saying you should not use a clustered index, I'm saying you should use it when it brings some value.

I've seen many tables where...

Jeff Moden (12/3/2010)

---

PaulB-TheOneAndOnly (12/3/2010)

---

May I spice this one?

Subjet of this thread is...

...and I say "so what?" 😀

There is...

May I spice this one?

Subjet of this thread is...

...and I say "so what?" 😀

There is the common missunderstanding...

Hope you are referring to Referential Integrity constraints.

Brandie Tarvin (12/3/2010)

---

Repopulating a table isn't necessarily that easy. Especially if it has foreign keys, indexes, constraints, etc. If it's a heap, then not so bad. But you're also forgetting...

RainbowFfolly (12/1/2010)

---

Come on Pablo, nothing could be easier to understand - members of The Beatles in descending order of popularity! Admittedly, it might confuse and upset those end-users wearing...

I think this is a job for "Captain Obvious"! 😀

How about creating a new table, populating the new table and dropping the old one?

:pinch: business specs with a simple numeric example wouldn't hurt.