Viewing 4 posts - 1 through 4 (of 4 total)
Wallace Houston, Instead of " AND isnull(p.TrackingNumber,'') <> '' "
I would sugguest to use
AND p.TrackingNumber=p.TrackingNumber
this code will ignore all NULL values and also works for all datatypes.
June 21, 2012 at 4:24 am
It looks like some of your queries are scanning complete table than using indexes, validate your code Vs existing indexes.
June 12, 2007 at 12:05 am
You can use query to know number of open connection for the month Jan 2007 for your typical case.
SELECT hostname, uid=rtrim(loginame), Program_name=rtrim(Program_name), dbname=db_name(dbid), status=rtrim(status)
FROM master.dbo.sysprocesses
where Program_name =...
June 11, 2007 at 7:02 am
If you are unable to trace back your code and fix the problem. Try with different connection string for each month and also add "Application Name" in the connection string and...
June 11, 2007 at 6:53 am
Viewing 4 posts - 1 through 4 (of 4 total)