Oops, I run bi-directional replication (both servers publish/subscribe to each other), so I assumed you did too even though you didn't say as such.

If you just go one direction you...

Why not add the additional columns to the table after allowing the snapshot to create/populate it?

You can change the schedule for any of the replication agents, but I don't know what the side affects are of only doing cleanup during evening hours (e.g. letting the...

Does the server have static IP? If so it may be simplest to just add a value in your hosts file (%windir%\system32\drivers\etc\hosts) that points the new server name to the...

Probably where you are encountering issues is the @sync_type of sp_addsubscription. You want this to be 'replication support only' if the table and data are already identical on both servers...

I would not plan against the targetted RTM time frame from 2008. Not only is this date likely to slip (based only on the fact that all RTM dates are),...

I can speak from personal experience that Microsoft has major parking issues at the moment. They already make huge efforts to encourage commutes other than single occupant vehicles, but the...

About a month ago we found ourselves wanting better availability, preferably with better scalability as well. As you may guess however, the machine & software budget is limited.

I think there are some nicer solutions here than mine, but I went with a dumb cte approach that seems to work decent. I was surprised to see how many...

I think that execution time is only one piece of the puzzle. For my needs (back end to web server), if an SP executes in .1 seconds I'm typically in...

Haven't tried it, but couldn't you just use a ranking function over ordering by the clustered index key to get a pseudo identity column? I can't think of any drawback...

I'll add this - you can have only one clustered index on a table because that index causes the entire data of the table to essentially become an index.

You can...

You can just cast the nvarchar column to xml, but this obviously incurs the overhead of parsing the content and would error out if the column contains invalid xml.

use tempdb;

create...

Hugo,

It sounds like you have the luxury of getting to define your own database schema. In the small company that I work for, the database guy (yours truly) has to...

I'm trying to visualize a life of bitmasks without bitwise operators. I just had to disable bit 1 on a bunch of rows, and then later reenable bit 1. How...