You can do an upgrade one of three ways, an inplace upgrade, as you've been discussing, a back up & restore or detach and attach. Any of the three will...

Generally speaking, no, non-clustered indexes aren't going to hurt your clustered index, but...

On another reading through the code, I think I'm going to eat crow and agree. That was a better approach and I'm wrong about it. I should have looked more...

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...