Difficult to say what the issue is.

If you want to look at hardware then do you have separate disks for the tr log and are backups taken to a different...

Those should help but really need to know where the issues are.

Can you materialise the datasets you are using and maybe update them from triggers.

It looks like the table structure...

Looks like the loop is just splitting up comma delimitted lists from @t2

This would mean you don't need the identity.

insert @t3

select distinct SUBSTRING(Column1, 1,PATINDEX('%,%',Column1))

from @t2

while @@ROWCOUNT 0

begin

update @t2

set Column1...

Assume you've dealt with indexing and such

A few obvious comments

Could you change union to union all?

in (select DISTINCT Column1 from @t3)

Could you ensure unique values in @t3 rather than using...

A linked server is just a method of querying the remote server.

You have to issue sql statements to extract data

select *

from LinkedServer.dbname.dbo.tblname

where .....

it doesn't do anything automatically with regards to...

If there's nothing to say when a row is updated then you are stuck with transferring the whole table (or checksums) and checking it.

Not feasible if the table is large...

So you are updating your local copy of the database from the server?

Does the table have anything to say when a row was updated? A last updated column, a timestamp,...

>> always the same columns is returned

>> q.*

Both dangerous statements.

Does q have a simple PK?

If so I would return the those values then join to q to get the data.

Whether...

Are you asying that you have data on your local machine which is being accessed from the server to support queries (to avoid data duplication)?

I would go back to your...

Can you create a partitioned view.

No idea if this is still available in v2005 or how it's supported by standard edition.

Note it this is still on one disk you will...

Your only problem is the foreign key so the options are:

1. Support the integrity programatically - maybe by a trigger.

2. A single referenced table with possibly a lot of attributes...

I do this using sql fom the table definitions.

Create an SSIS package to import the data to a staging table (xml is created from a template and the source/destination columns...

Changing the collation of the user databases won't help - it only affects new tables that use the default collation. You would need to change the collation of all the...

Have a look at what it generates.

You will have two tables.

One will have a foreign key that references the other

create table manager

(

manager_id int

)

create table player

(

player_id int ,

manager_id int ,

foreign key...

Correct answer would be none of the above - as that's not an option a, b is obviously what's wanted.

You need to guess the answer required rather than what is...