A few links:

http://sqlserverperformance.wordpress.com/2010/11/11/hardware-201-selecting-and-sizing-database-hardware-for-oltp-performance/

http://blogs.msdn.com/b/bartd/archive/2010/06/16/sql-server-sizing-resources.aspx

If you don't have an existing system, it's all just a guess, and most people just guess high and hope for the best. Getting dual quad cores, maybe...

Craig Farrell (4/28/2011)

---

Steve Jones - SSC Editor (4/28/2011)

---

Since I have the collective braintrust here, and you're posting technical stuff.

I posted a note about understanding your access patterns for data, meaning...

There is still no guarantee of the ordering of the data. Regardless of how it is stored, it will not be returned by a SELECT in that order without an...

Grant Fritchey (4/28/2011)

---

Steve Jones - SSC Editor (4/28/2011)

---

Since I have the collective braintrust here, and you're posting technical stuff.

I posted a note about understanding your access patterns for data, meaning...

GilaMonster (4/28/2011)

---

Steve Jones - SSC Editor (4/28/2011)

---

Yes, but it's more that if you are querying large ranges in both OrderHeader and OrderDetails and possibly aggregating or adding in lookup information...

Really the basics, Tom. Something between the DB Design one Paul White wrote and the crazy relational debate. A "normalization" for dummies, and I'd like to have a separate article...

Since I have the collective braintrust here, and you're posting technical stuff.

I posted a note about understanding your access patterns for data, meaning hitting tables how often and how concurrently....

Yes, but it's more that if you are querying large ranges in both OrderHeader and OrderDetails and possibly aggregating or adding in lookup information from other indexes.

The benefit from separate...

Is DATENAME not something you want?

You're not really describing this well, either in your first post or this last one.

I'm not quite clear what you are doing here.

Can you provide a short sample of test data and the source? Is this is in a table or in XML for...

Syed Jahanzaib Bin hassan (4/28/2011)

---

I didnt say like this as you get ,snaphot database work with database which one is snaped shot,A database snapshot is a read-only, static view of...

I don't think that tempdb is ever redundant. It's used for a variety of things as mentioned above, and it isn't necessarily because of memory.

The restore syntax is the same. Not a big deal there. However the startup parameters for master might need to be changed in a DR situation. In the services applet,...

First, AFAIK, you cannot separate a table across filegroups. You can separate across files, but not filegroups. The exception is partitioning.

You can move a table's data to a new filegroup...

One thing to keep in mind, if you are looking for partial database recovery in a DR situation, moving the indexes away from the table can cause issues. Think about...