Per my research the ideal clustered index should be a narrow column and unique. We are currently on SQL Server 2012 and have a database setup for merge replication. I am in the process of adding a new table, StoreOPenDocume nts, to our database. I am unsure what the clustered index should be.

Table StoreOpenDocume nts
StoreOpenDocume ntsID defined as UniqueIdentifie r
CustomerID defined as UniqueIdentifie r...

We currently have a stored procedure with a few parameters and one of them is a list of invoice numbers that is comma separated.

The stored procedure creates a temp table, uses a local function to split out the invoice numbers, populate the temp table and uses the data in the temp table to select data from another table.

I would like to modify this stored procedure to add another parameters to control the sort order...

We currently have SQL Server 2000 and have merge replication. We have the following process

1. Data is transfered to a laptop, data on the laptop is changed and the data on the server is 'locked'
no changes can be made.

2. After a few days, the laptop is returned to the office.

3. A script is ran to delete the data on the publisher. Replication works,
the subscriber side is updated with...