It will need to be in both databases, or at least some version of it. Remember that Peer to Peer replication is in effect a series of transactional replicactions,...

Have a look at this article:

http://msdn.microsoft.com/en-us/library/hh710046.aspx

Just remember, the distributor is going to be the weak link in all of this, as it can not be a member of...

select FieldSet.value ('(/Fields/Field[@Key="Column1"]/@value)[1]', 'varchar(20)'),

FieldSet.value ('(/Fields/Field[@Key="Column2"]/@value)[1]', 'varchar(20)'),

FieldSet.value ('(/Fields/Field[@Key="Column3"]/@value)[1]', 'varchar(20)'),

FieldSet.value ('(/Fields/Field[@Key="Column4"]/@value)[1]', 'varchar(20)')

from #temp

Whatever account that is running SQL Server on your laptop does not have permissions on the directory you mention. Look in Services to see what the account you need...

I think there was a change in the licensing recently. Under SQL 2014 licensing, you need to buy SA (Software Assurance) for the passive failover node(s). I am...

There are a range of third party backup software packages that could do this sort of thing. A lot of them will populate a name for the backup, or...

If repair_allow_data_loss is the least option it is giving you, then you can be fairly certain that some data will be lost. The range you specify has a lot...

The usual suspects are triggers, but you dropped and rebuilt the table. What is the wait_type in sys.dm_exec_requests for the session, when you are running the insert?

You might want to limit the instances to individual cores by using the affinity mask configuration item. This should prevent the threads being bounced all over the place, and...

I am compelled to post this link here:

XKCD: What if[/url]

You can check to see if the query plans match up, by running this query while the application is running the query:

select p.query_plan

from sys.dm_exec_requests r cross apply

sys.dm_exec_query_plan(r.plan_handle) p

where r.session_id =...

You should be able to use the same port. The dynamic port number is just a preferred port for the service. If on startup, the port is in...

Reorganizing indexes will generate a lot more transaction log activity, as each row moved will need an entry. For highly fragmented tables, it will also take more time.

On the first point, I certainly agree. I am beginning to hate applications based on Java for this reason (among several others).

The second point, I have no reason to...

Is the date column the first column in the clustered index? If not, then you will have a scan. If it is the first column in the clustered...