Some questions to check:

- What about the statistics?

- Are they up to date (check with DBCC SHOW_STATISTICS ( table , target ))?

- Do you have the same amount of data?

-...

I still do not understand well your select but I have some issues with that:

- Why do you have this interresting where clause: "WHERE 0=0"

- you should remove (AR.Transaction_Type IN...

Just a stupid question:

- Are all your indexes participating in the primary-forign key pairs all right and well defined?

- Do you have triggers defined on the participating tables

If your...

SQLBill is right.

If any of your disk (of cours I mean here disk array - RAID1, RAID5...) hosting the data, index, Log, system, tempdb fails you won't be able to...

What does it mean Select @seq from ( select SeqNbr deom DELETED ).

It is incorrect.

You have to type:

select @seq = SeqNbr from DELETED

But do not forget that you...

Why not to use a temporary table or table variable, insert your data then select then at once?

Bye

Gabor

I suppose you are prepared to handle the licencing issue. i.e. you have a processor licence instead of server/CAL based licence otherwise you wont be able (or allowed to access...

Inserting one million records in one batch represents 2 kind of problems:

- Log space

- Tempdb space if the source you are selecting from involves the tempdb (temp table, sort, group...

Yes but the book of Kalen is not really for novices!

But of course it gives you a complete picture what is going on behind the scene.

Bye

Gabor

We have an SAP over here.

A lot of modules, over 1000 users, the DB size of the productive DB is 250 GB after 1,5 years and the size grow is...

As long as you have an order by clause you cursor will be read only!

I've xperienced that problem as well.

The only way is to implement a clustered index to get...

The "read only" flag as you want to implement is application specific. i.e. in you enduser app (VB, Delphi, C#...) you have to define you recordset or data grid as...

Steve,

In your case, as I've already told you, you should implement a kind of search form where the user is entereing the search criteria and based on those criteria you...

I personnaly don't like that kind of programing behavior in a client/server environment.

That one fits well on a standalone database/application of Clipper/ACCESS... type of database.

I usually let enter the key...