You can use the SQL Server view sys.dm_io_virtual_file_stats to see IO Stall Time. Around 7 ms is average, anything above 20 ms is considered poor, and above 50 ms is...

If this is an OLAP environment CXPACKET is a good thing, and you would want it to be > 10%. If this is an OLTP environment CXPACKET > 5%...

Object IDs are described here:

http://en.wikipedia.org/wiki/Object_identifier

This is how they get encoded into a compact form:

http://msdn.microsoft.com/en-us/library/windows/desktop/bb540809(v=vs.85).aspx

C# code is here:

http://www.codeproject.com/KB/cs/Oid_Conversion.aspx

Here are some additional sections (revised):

-Upgrade (to latest release)

-Data Access Layer (LINQ, ADO.NET, ODBC, JDBC, RBAR marshalling)

-Conversion (to/from non-Microsoft SQL Server DBMS)

-Schema Design (logical & physical)

-SQL questions & solutions

-XML storage...

Here are some additional sections:

-Upgrade (to latest release)

-Data Access Layer (LINQ, ADO.NET, ODBC, JDBC, marshalling)

-Conversion (to/from non-SQL Server DBMS)

-Schema Design

Performance Tuning can be broken down into:

-System & Network Configuration &...