Sign up as in sign up for the SQLServerCentral party? Do you have more details of it? I might be flying in on tuesday. Dont know my travel plans yet....

Wanted to bring this thread up. My company is sending me up there

Steve are you gonna be there?

Anyone else showing up?

What/Who is stopping you from putting DBA in your resume?

I would say it could be all of above.

(1) Bump up the memory

(2) Yes dual core would help.

(3) An immediate improvement can be seen if you move the table to...

Yes, as the message says you need to drop the subscription and re create it. Also, to make sure this doesnt happen again, ther's a check box for expiration date...

Generally its the nature of "consulting" that you need to change jobs frequently about 6 mo/s -1 yr because thats the primary reason companies bring in consultants. The projects are...

Are you exactly comparing apples to apples? Are you a FT employee with some additional benefits? Generally contractors get paid more hourly but they dont get any benefits - no...

So there's no primary key on master table?

You could do a distinct from master and perhaps use an aggregate from the child table with a LEFT JOIN.

I dont think so. You can however have a trigger fired up to apply the formula if the value inserted is 'X'.

The data files would be copied to the ReplData folder which you would have specified when setting up the replication. Generally its a network path common to both servers. The...

See if you can put the 3 tables in different file groups across different drives. And like the other posters mentioned, do an UPDATE STATISTICS (withough full scan) and see...

You could find some good info on http://www.replicationanswers.com. There are some good articles on SQLServercentral.com too.

To see a performance difference, time the query that you replaced and the view separately and compare before you plug it into your stored proc. Do all the join fields...

did you refresh the monitor and see?

Also you dont have to drop the entire publication for one table. You could drop the table only from the publication:

exec sp_dropsubscription ...

You could do it in a batch. Also have a job running (perhaps every minute) to truncate the log.