tshad (5/28/2014)

---

I can't understand why this won't work. I do this all the time.

I created a dummy database (TomsTest) and then I try to restore my other database "DEV"...

Thanks for the question Steve.

I'd like to see Resource Governor someday be extended to include those other options.

Yeah it is

I have seen both of those methods used successfully in performance tuning exercises.

Check out the Code sample I have in this article http://jasonbrimhall.info/2014/05/23/can-you-partition-a-temporary-table/

You'll see that I drop the temp table at the beginning if it exists. I run this code over...

Here is an interesting article on the effects of a rebuild vs. reorg. The effects of the article seem pretty consistent whether clustering on a GUID or Int and...

Jason Selburg (5/28/2014)

---

SQLRNNR (5/28/2014)

---

TheSQLGuru (5/28/2014)

---

SQLRNNR (5/28/2014)

---

TheSQLGuru (5/28/2014)

---

Another vote for Red-Gate SQL Compare. There are a number of...

TheSQLGuru (5/28/2014)

---

SQLRNNR (5/28/2014)

---

TheSQLGuru (5/28/2014)

---

Another vote for Red-Gate SQL Compare. There are a number of other options from...

I'm of the opinion that tables should have clustered indexes.

With an index scan versus a table scan, the index being smaller (if just on the ID) could be less impact....

Is ID going to be your most commonly queried field in that table?

The thread looks very interesting. Too bad it got hit with payday loan spam.

I lumped that in to my "notifications."

I only receive one newsletter. Maybe Steve can have somebody look deeper into your account. But...

TheSQLGuru (5/28/2014)

---

Another vote for Red-Gate SQL Compare. There are a number of other options from third parties...

For a rebuild, you generally want to have enough free space to cover your largest index and then add some for breathing room.

If you decide to do a reorg instead...

It doesn't appear to be a global issue. I am only receiving one email for each notification.