Thanks for the quick reply.

But the problem is the company does NOT allow to run the profiler due to some policies. hence I was trying to find if ther is...

There are 2 suggestion for this:

1: Remove count(*) and replace it with count(any one INTEGER type column). Here all you are doing is checking if there is any row >...

Hi, I am using the "Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (X64) Mar 29 2009 10:11:52 Copyright (c) 1988-2008 Microsoft Corporation Standard Edition (64-bit)...