I want to make you aware of a latest SQL Server 2008 hotfix documented in http://support.microsoft.com/kb/2791745 .   Using large number of constants in IN clause can result in SQL Server termination unexpectedly.   When this happens ...read more