I have the same problem with a query which has many LEFT JOINs. And for some LEFT JOINs I have bad seek index. For example:

SELECT s.nrintstoc, s.tipdoc FROM

...

Hi,

I have almost the same HW configuration. And have to move to another strongest station. Until then, because we have a lot of BlkBy, I moved TempDB to an RAMdisk...

I know that this flag is for reading extents of 64 k, ok, I give up of this issue.

I know these commands, but I referred to the data itself not the objects of sql server like tables, triggers, stored proc. etc.

... and how do you know the structure of data is one good?

I didn't make the design and arhictecture of this ERP system. Anyway, the tables are plenty of indexes. I've tested the stored procedures, some of them because are a lot...

So, I have the following difference for 1 day:

Unit          FileName         BytesRead     BytesWritten

GBytes      tempdev          21.9             24.7

MBytes      templog           1.82             1382.93    

I try to understand how...

I have the following IO on TempDB:

15 aug 2007:

how about RAID10 array? is justified to use 6 HDD?

Thank you for your replies. I will analyze these issues you show me.

Hi,

Thanks for your replies.

Erik, your first point is interesting. Anyway, if something is damaged to system databases, it should be restored from backups

Second point. Obviously, my concern is about duration of...

I think I should put an index on data_sf. I just wonder if it exists another method to quickly update.

1) no index on data_sf

2) ok, it is processing 10000 records, how about the other records? is there a way of

avoiding "while" mechanism - row by row. I know...

Hi Ali,

I have tested my query against a test database with exactly your data tables and it works well. As Chris said, I should replace NULL values with zeroes, but...

There is the sql:

SELECT     MyList.[Name], MyList.DOB,

Count(Library.[Name]) as [Total in Library],Sum(Library.Completed) as [LibraryCompleted],

Count(Channel.[Name]) as [Total in Channel],Sum(Channel.Completed) as [ChannelCompleted]

FROM         MyList  LEFT OUTER JOIN

                      Library ON MyList.[Name] = Library.[Name]

   LEFT OUTER JOIN

                     ...