CPU power has increased, but a great talk from Dr. David Dewitt in 2009 at the PASS Summit showed that disk xfer rates have not. The capacity has, but the...

Hope everyone had a good evening last night, welcome to 2011, and best wishes.

Solomon Rutzky (12/31/2010)

---

Now, Steve mentioned "Regardless of what columns are in the nonclustered index, the clustering key is there" which is not always true. It is most often true, but...

Keep in mind this is a piece of the puzzle. Some languages, like some of the Java clients, will only work with nvarchar formats, and if your db is in...

Interesting story, and good advice.

Thanks, couldn't remember that. I was thinking it was 2 + 2 for the variable portion. I was wrong.

http://msdn.microsoft.com/en-us/library/ms177484.aspx

If you choose an identity for your clustering key, that identity is...

I saw Chronicles, and it was good. I hadn't seen the other two, but this made me want to go rent them.

Iron Man 2 and Red are now on my...

Happy New Year, to all the threadizens. I know a few of you kiwis and Aussies are celebrating. About 14 hours to go here.

No worries, and no hurry on this stuff.

I'll likely review it next week and get you feedback.

No hurry.

If you want to write a separate one for a checklist, a short list that references the logs article, that's fine as well. Could always use more info here...

I tend to agree with Harry. You need to check how your hardware supports the additon.

For R5, it starts to add in the data and rebalance across all disks, which...

You should not need to shrink, as noted above. Set the log to the size that is needed between checkpoints, or for your largest transaction.

If it grows, check the replication...

sqldba_icon (12/29/2010)

---

Can you please give me some details like what performance hits will we come across or if you can point me to a article that would also be helpful....

Steve doesn't have horses. Steve's wife has horses, Steve loves...