I've done it both ways and either will work, but in the long run, keeping the PK name the same throughout the structure seems to lead to less confusion.

I'm inclined to say the second without any data. But I've seen instances where the first can be faster.

Testing and examining the execution plans are the only way to be...

They are two different things.

A trigger fires in response to either data manipulation, a DML trigger, or certain structural changes, a DDL trigger.

A stored procedure is a piece of TSQL...

Paul just twittered that he was finishing the first draft of the 2008 version.

Bob Hovious (1/21/2009)

---

Now that I read the thread, I have a scene from "Jerry Maguire" running through my head AND IT WON'T COME OUT. Thanks, Ninja.

I don't have...

Bob Hovious (1/21/2009)

---

Now that I read the thread, I have a scene from "Jerry Maguire" running through my head AND IT WON'T COME OUT. Thanks, Ninja.

I don't have...

Lynn Pettis (1/21/2009)

---

GSquared (1/21/2009)

---

Yeah, but did you see the reply to that?

What's up with the grapes table that only has a priority column? What does that have to do...

Lynn Pettis (1/21/2009)

---

Grant Fritchey (1/21/2009)

---

This is the second time this exact question has been posted:

http://www.sqlservercentral.com/Forums/Topic640498-1291-1.aspx

No answers to the questions, no further interaction at all. I wouldn't be surprised to see...

Michael Earl (1/21/2009)

---

Lynn Pettis (1/21/2009)

---

Grant Fritchey (1/21/2009)

---

This is the second time this exact question has been posted:

http://www.sqlservercentral.com/Forums/Topic640498-1291-1.aspx

No answers to the questions, no further interaction at all. I wouldn't be surprised...

Matthew Zuberko (1/21/2009)

---

Hello,

I have a view which includes joins to a single table view and a single table subquery, and UDF is called in the column list. The query runs...

This is the second time this exact question has been posted:

http://www.sqlservercentral.com/Forums/Topic640498-1291-1.aspx

No answers to the questions, no further interaction at all. I wouldn't be surprised to see it again in two...

First, a question, you're moving 1.8 million rows out of the EventInformation_rob table. How many rows total are in the table? If you're moving most of the table, you're going...

I'd suggest getting a copy of the book "Database Administration" by Craig Mullins. It's not technical and it doesn't focus on SQL Server at all. Instead it talks about the...

I thought I remembered seeing that before.

george sibbald (1/21/2009)

---

Grant Fritchey (1/21/2009)

---

The overwhelming majority of our production systems are 2000. We're starting an initiative this year to get them upgraded to 2008 over the next two years...