Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

DB NewsFeed

Matan Yungman is a SQL Server DBA at the Microsoft Protection Services operations team. He fell in love with T-SQL in 2003 and since then took part in various challenging projects, focusing mainly on performance tuning, database development, high availability and database design. He is passionate about SQL Server, databases and technology in general.

Archives: February 2014

The Strange Story About the MERGE that Killed the Cluster

I don’t like the MERGE statement. The syntax is weird, it’s tricky in terms of locks, and it has a history of weird errors. The other day a developer wanted my help in troubleshooting a MERGE that caused an ACCESS VIOLATION error and a stack dump generation. That… Read more

15 comments, 3,232 reads

Posted in DB NewsFeed on 20 February 2014