SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: December 2009

transactional replication:initialize with backup

I spend this weekend playing with transaction replication and try to set it up so that I don't have to synchronize it from snapshot.

The following article was helpful up to a certain point http://msdn.microsoft.com/en-us/library/ms147834.aspx.  I spend a lot of time trying to figure out how I could follow the… Read more

3 comments, 989 reads

Posted in Sopheap Suy on 6 December 2009

a simple joint that makes you think twice

I was reading Two Minute SQL Server Stumpers a few weeks ago and this qustion still sticks in my head.  Thanks to SSC for giving it away at PASS :)

SELECT * FROM dbo.Customer MIDDLE JOIN dbo.Employee on CustomerID=EmployeeID.

This puzzle me because I have never heard of a middle… Read more

0 comments, 526 reads

Posted in Sopheap Suy on 1 December 2009