Continuous or Scheduled Replication (my two cents)
Produced: 26/05/2013 14:37:00
This defines how often the SQL Server Agent job runs… does it run to a schedule, or does the job run continuously.

Each time the agent runs, any outstanding replicated data is passed from the distributor to the subscriber.

At this point I have to say that I believe Continuous to be a very bad choice and will only ever use a schedule for my replications. People may argue that this is incorrect, but I do have my reasons:

Continued...
How to Subscribe to a Publication
Produced: 19/05/2013 19:50:00
Once you have created your publication you will need to subscribe to it (otherwise it’s pretty pointless really).

You can start the Subscription wizard from either the Publisher or the Subscriber by clicking as follows:

Continued...
PATINDEX
Produced: 12/05/2013 18:46:00
In terms of functionality, this is very similar to CHARINDEX in that it simply looks for a pattern within a string.

However, where it differs is that PATINDEX requires you to use wildcard characters as part of your search, something that CHARINDEX will not, but it is less powerful in some ways in that it does not allow you to specify a starting point and therefore will only ever find the first occurrence of a pattern in a string.

Continued...
How to Create a Publication
Produced: 05/05/2013 16:27:00
This is generic guide as, to be honest, setting up all replication is pretty much the same. There are a couple of extra screens for Merge replication and I’ll highlight those where necessary. Otherwise it’s all the same.

Continued...