Archives: December 2009
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