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

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