tstaker (3/18/2010)

---

GSquared (3/18/2010)

---

john.arnott (3/18/2010)

---

Sometimes I think about teasing my DBA by saying stuff like "since clustered indexes are better than non-clustered,...

This is a point that I...

You're welcome.

NP

You will see several examples at http://ask.sqlservercentral.com/questions/4241/whats-the-best-way-to-solve-the-fizzbuzz-question

Last comment for the moment. I like the principle of this script. Nice idea and it looks like it could be very helpful.

Thanks.

JStiney (3/18/2010)

---

I would like to run your script, but I get invalid characters in blank spaces when I copied it out of the window and ran it in Management Studio....

Mark D Powell (3/18/2010)

---

I copied it into notepad and used the edit/replace option to replace a copy/paste of the stupid little squate box to space. That seemed to work...

J-F Bergeron (3/18/2010)

---

Thanks for the vote of confidence Jason, 😛

We do not know if the...

It should be more like this

alter table TableName Drop constraint FK_Name

Then perform your truncate

Then this

alter table TableName

Add constraint FK_Name Foreign Key (FieldName) References OtherTable (FieldName)

Paul,

I am curious why you changed your alias to include NZ.

Elliott W (3/18/2010)

---

Matt Miller (#4) (3/18/2010)

---

Elliott W (3/18/2010)

---

Before saying "don't use SSIS for this" you need to ask more questions. The biggest one is how much data are we...

J-F Bergeron (3/18/2010)

---

Here is a query you can use, but you will need to add a datetime field you probably have in your table in the sorting. It's just a...

Lynn Pettis (3/18/2010)

---

Speaking of the...

john.arnott (3/18/2010)

---

Sometimes I think about teasing my DBA by saying stuff like "since clustered indexes are better than non-clustered, could...