Monthly Archives: August 2005

Data type conversion for AVG

Run the following script:   create table test (C1 int not null)GOINSERT  test values (1000000000)INSERT test values (1000000001)INSERT  test values (1000000002)GO   What result the following query will give? SELECT SUM(c1) from test Yes. It gives value overflow error because the … Continue reading

Posted in SQL server | 1 Comment

Quick facts about the capability of SQL server 2000 cluster failover and resources

Quick facts about the capability of SQL server 2000 cluster failover:1) The SQL Server 2000 Analysis Services (OLAP and data mining) component is not supported on a failover cluster. For more information, see the Knowledge Base article "254321 – Clustered … Continue reading

Posted in SQL server | Leave a comment