doing something I enjoy to earn enough for myself and family to do other things we enjoy.

there's some stuff about wanting to be better all the time, being told I'm...

sorry - just wanted to say that I can't compare 64 bit as I don't have one of those ( yet ) to play with, but I'm told by a...

I think you need to check that parallelism is not your problem, you can check this with the query plan in QA or failing that adding  maxdop 1 to your...

Take object out of replication:-

Use publishing_database

go

--

exec dbo.sp_dropsubscription  @publication='publication_name',@article='object_name',@subscriber='subscriber_server_name'

go

exec dbo.sp_droparticle @publication='publication_name',@article='object_name',@force_invalidate_snapshot=1

go

exec dbo.sp_refreshsubscriptions  'publication_name'

go

do whatever you want to the object:-

then put it back

Use publishing_database

go

--

-- put them back

--

exec dbo.sp_addarticle 'publication_name',@article='object_name',@source_table='table_name',@destination_table='table_name',@force_invalidate_snapshot=1

go

exec dbo.sp_refreshsubscriptions  'publication_name'

go

--

-- do...

Rather than messing with the hardware,  you need to extract the query and its query plan, either with profiler or QA and examine the plan to see exactly what is...

will do - haven't forgotten!

Important .. task manager does not report actual memory usage when awe is enabled. The values in sysperinfo table are correct, I use this as a question for DBA's in...

use tsql to add the table, refresh and run the snapshot job - ( it should ) does for me only refresh the new object.

you need

exec dbo.sp_addarticle

sp_refreshsubscriptions

then

exec msdb.dbo.sp_start_job @job_name {...

you missed something < grin >

essentially replication is of data, not objects,  so if you add or modify objects you need to update the schema. I do this through T-SQL...

Past experience has shown that incompatible sps can lead to problems.

I'd suggest you don't mix service packs this way. It certainly gave me problems on clusters. ( nodes not all...

It's an interesting problem which may have a number of possible solutions.

• Complex stored procs may work better if split into smaller less complex procs.
• Adding a recompile to the...

to do any of this type of work you'll need to take the database into read/write. Use the alter database command either side of your optimisation job.

I believe http://www.sysinternals.com/ has a defrag tool that handles different block size.

I'm told diskkeeper does too. My current employer only uses default so I've not had reason to look into...

any sarg that uses a leading % will have to table scan which is very expensive. Do you need the leading % ?

Yup I sat through part of a microsoft presentation ( sorry guys name forgotten but he is one of the gods of computing ) and he said that with the...