Slow query response time in SQL Server 2005


Answer Question   |  October 27, 2009  4:30 PM
Query, Slow SQL Query

Slow SQL Query
when i run below all SQL Query simulataneously against 1500000 Rows its take 10 minutes i put the non-clustered index on the columns TATCallType ,CallTo the data type of both columns is varchar select ID,AuditMaster_ID,CallTo,CallTypeTag into Auditdata_callto from auditdata where AuditData.TATCallType is null and substring(AuditData.CallTo,1,convert(int,0))=” and len(AuditData.CallTo)=10 select ID,AuditMaster_ID,CallTo,CallTypeTag into Auditdata_callto from auditdata where AuditData.TATCallType [...]

Answer Question   |  July 14, 2009  10:00 AM
Slow SQL Query, SQL queries, SQL query optimization