make sure you join with the new table then in order not to delete fresh finished records.

1) cursors are mostly used as last resorts (because they are such a performance drain on the server) to implement complex logic. Beginners tend to use them also because it...

1) is there any firewall in between?

2) What is the OS of your sql server and is sql server patched up to at least SP3+hotfix or SP4?

Can you trace the sql statements sent to sql server using sql profiler?

You can then analyze the query plans in the query analyzer (display estimated query plan)

Possible causes:

a query is...

1)Haven't really got that situation myself, but it can be because connections aren't closed as quickly as possible after their use.

http://www.15seconds.com/issue/040830.htm

3) It all depends wath the server will do,...

You don't need to take a database offline to back it up.

Attaching/detaching: allows to copy the mdf/ldf files.

does the sql agent account has the rights to start the reindexing?

* are your insert and update 2 different actions/inserts. Could it be that one connections uses the default dateformat (us_english m/d/y)

the only things that really helps is having the client updating...

I would start with backup/restore

Than security

Then see other topics above.

I didn't have the need yet to use DTS packages or SQLMail.

*misread*

Excuse me, my mind is a bit troubled.

The scripts was well done

Can you post an example of wanted output? Do you mean like a roster?

Squadrons

        list of divisions

                   list of...

This is because the order of execution. JOINS before where, where before having...

select Label,Color,SampleLabel

from TblSample

LEFT OUTER JOIN VWClosedSampleQuotaView X

 ON TblSample.Label = X.SampleLabel

gives

Label Color SampleLabel

Alice Red Alice

Bob Red Bob

Cathy Red Cathy

David Blue David

Ellen Blue Ellen

Fred Blue Fred

Gale Yellow Gale

Harold Yellow Harold

Irene Yellow Irene

Apply where clause SampleLabel-> no records...

Table structure looks fine.

Can you rescript your table generation? It gives some errors on tablenames.

If you want to see the strict org structure, choose inner joins instead of left-joins.

generally the more spindles the better

Although using 16 drives oposed to 3 raises some questions.

Large drivers are generally more modern than smaller ones, and you get extra management with so...

Shooting a bit in the dark: could it be that with ANSI_NULLS ON it will have to join less data (since  = NULL always gives false) and somehow the optimizer...

What machine is it?

Does it has all patches?

Did occur it suddenly? If so any clue what has changed? (network, new machines...)