I was always told in Windows NT courses to think Globally act Locally still applied. Meaning put your users in your domains into Global groups then put those global groups...

For others bennifit and the fact it helps me understand better could you post an example of the data you are currently getting and an example of what you want...

Besides the fact LiteSpeed compresses as it does the backup conserves space. Might also consider getting a higher speed dedicated network between the servers so when you do you backup...

ANd I think the entire segment of code would be usefull for us to understand what you are really doing. You actually should be able to get better preformance out...

I agree, that book will probably be the best resource for the questions you are asking. But as far as background process there really aren't truely any. Within SQL there...

You can create shared namespaces I beleive or as more commonly done you create a signaling method for all processes to transfer the data thru for each to see. The DLL...

Do you mean Firewall Protocol or what is this in reference too?

A process is the encapsulation of a running program on a given platform. It provides the context in which thread(s) an carry out the work of an application. A process...

Also try something like this to see if it doesn't perform better:

SELECT

 addr.sysrecno,

 addr.access,

 addr.address_seq_no

FROM

 dbo.address addr

LEFT JOIN

 dbo.commlmk clmk

ON

 clmk.address_seq_no = addr.address_seq_no

LEFT JOIN

 dbo.garacc agar

ON

 agar.address_seq_no = addr.address_seq_no

LEFT JOIN

 dbo.carrier carr

ON

 carr.address_seq_no = addr.address_seq_no

WHERE

 -- If SQL 2000

 Coalesce(clmk.address_seq_no,...

The simplest answer to give is you have inserts that are failing. Run profiler for a while and see if you have any inserts that fail and rollback. If so...

Express verions (the next MSDE) is downloadable from their site. For the Beta thou you either have to be on the current Beta, have an MSDN subscription with the downloadable...

Sorry you misunderstood. I didn't say Exists was better but for the same reason a column from table A can be referenced in the Exists Subquery it will do the...

Generally you have two options, 1 make a text field or 2 place each into a seperate table which can be joined to to rebuild the original required results. But...

This sort of thing has been posted about many times before.

Instead of writing this way:

select ColumnA from TableA where ColumnB IN (select ColumnZ from TableB)

Do this:

select ColumnA from TableA...

Try adding the following before the insert.

SET IDENTITY_INSERT [ database. [ owner. ] ] { table } { ON | OFF }

Use the ON parameter and it should ignore you...