Posted by Erland Sommarskog on 12/05/07 14:54

Taw (tawfiq.choudhury@grameenphone.com) writes:
> The following query which used to run regularly is crashing the
> server. The query is run on two tables which has aroung 60 million
> records each.

Does the entire server really crash, or is just the process terminated.

> Of course the query can be broken up and optimized I am just
> interested to know if any one has any clue why this is happening?

As Greg said, the most likely reason is a bug in SQL Server. The other
alternative is a hardware problem (bad memory, bad disk sector).

If you open a case with Microsoft, they have a fix that addresses the
bug. But it's more likely that you will arrive at a working query by
tweaking in a bit, possibly using temp tables for intermediate storage.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]