Small correction...

with cteResursive(BaseRecordId,RecordID, ParentRecordID, Credit)

as

(

Select RecordId,RecordId,ParentRecordId,Credit

from yourTab

where ParentRecordId is null

union all

...

Ahhh them were the days , a CGA card, floppy disks, 286 processors.

Off the top of my head....

with cteResursive(BaseRecordId,RecordID, ParentRecordID, Credit)

as

(

Select RecordId,RecordId,ParentRecordId,Credit

from yourTab

where ParentRecordId is null

...

IIRC it wasnt a turbo button , it was a 'go-slow for compatibility' button. I think 'turbo' is a better marketing term though

i think he already...

GilaMonster (7/13/2009)

I was referring to one of the other of his threads, the one that Dave posted.

SELECT <lots> FROM <somewhere> WHERE tatcalltype = 'null' AND <other conditions>

Done, apparently, because 'null'...

Select into will be faster if 'select into/bulkcopy' is set in sp_dbOption as it will be a non-logged operation.

My First thoughts are to create a nightly , 'Year to date' table of the summarised data.

Obviously 99% of the users have no updates throughout the day so...

Since you are returning ALL the Records , indexing cannot help.

SqlServer is executing the query as fast as it can, Its now going to be a hardware issue if...

Time for some row counts

select count(*) from AuditData

go

select count(*) from AuditData where TATCallType = 'null'

go

select count(*) from AuditData where Calltolen=12

go

select count(*) from AuditData where CallTo like...

Hi ,

when it says

you are supposed to do your query

You can lead a horse to water but you cant force him to drink

http://www.sqlservercentral.com/Forums/Topic751918-8-2.aspx?Update=1

That is not what is required.

Please read the article http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Please post the query plan as per this[/url] article.

We are just guessing at what may help you. With the query plan we may know what will help you

Heres my thoughts....

You seem to care a lot about the length of AuditData.CallTo , add a column to AuditData and update it with the value. Add an index...