SQL Server version and supported High availabile futures

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

SQL SERVER TOP STATISTICS

Category	Metric
Largest Single Database	80 TB
Largest Table	20 TB
Biggest total data 1 customer	2.5 PB
Highest transactions per second  1db	36,000
Fastest I/O subsystem in Production	18 GB/Sec
Fastest real time  cube	15 sec latency
Data load for 1 TB	20 min
Largest cube	4.2 TB

Upgrading SQL Server SP3 64bit in Cluster environment ..Good sites

Upgrading  SQL Server SP3 64bit service pack  in Cluster environment  with minimum downtime.

http://www.sqlserverdba.co.cc/2010/04/minimize-downtime-sql-server-2005-sp3.html

Best link for Upgrade SQL Server 2005 SP3 service pack .....

http://www.sqlcoffee.com/Tips0007.htm

http://www.db-staff.com/index.php/microsoft-sql-server/87-upgrade-sql-2005-cluster-to-sp3

DEAD LOCK - WHEN DEAD locks occur (Six reasons)

DEAD LOCK

WHEN DEAD locks occur

1.      Different  transactions trying to accessing the same table object

2.      Log running quires

3.      Lack of proper indexing

4.      Poorly written code

5.      Hardware bottlenecks

6.      Higher Isolation level(other than Read committee)