Did you apply a snapshop to initialize the new subscriber?

Yes, you can get more info by using trace/profiler to grab the data of what is happening with these spids at that time.

http://www.sqlservercentral.com/articles/deadlock/65658/

http://www.sqlservercentral.com/articles/deadlock/65614/

Read this: http://msdn.microsoft.com/en-us/library/ms187445.aspx

However the big factor is how much growth you are going to have from new data. If you have no idea what load you'll have, however people will...

I tend to agree with Jason here. What you do on your time off, really isn't the business of your employer, provided you are not representing them. You shouldn't...

What you probably want to do is combine this logic into your select. As you look to insert data, add the "logic" check into the WHERE clause.

insert TransferTable

select Product, AmountToReorder

...

I'm not a big Access guy, so I'm not sure what you do there. You need to be able to open it. I might open Access and then see if...

These folders are where the error log files are stored for SQL Server. What you can do is check how many you have and decide if you can delete old...

The Access upsizing wizard should move the data. That's what I'd do, that way things will continue to work as they are. I'd use this as a backup, and then...

Most of these are answered in Books Online.

To get the web server to move, you'd need to change the web.config unless you have the new SNAC client. In that case,...

You can move databases as Gail mentioned for user databases. If you need to move system databases, there are other procedures.

You really need to provide more details and explain what you are trying to do. Include some sample data that shows what checks you want to do.

Ha! always tan, but true, a new shirt.

Actually two. The M-R pictures are different from Fri.

There are a few possibilities, but please provide more information as SilverFox has noted.

One way is to set up a surrogate key as a GUID. They can be uniquely generated...

Please do not cross post

Answer here: http://www.sqlservercentral.com/Forums/Topic773592-146-1.aspx

Interesting splits of opinion here.

I don't think there is a great benefit to an employee here for sure. I guess you can work with people for a couple days and...