Sergejack, here are a few of the bugs with MERGE. Some may be worked out. - [Merge Statement Bypasses Referential Integrity](http://connect.microsoft.com/SQLServer/feedback/details/357419/merge-statement-bypasses-referential-integrity) - [Parameteri...

Sergejack, here are a few of the bugs with MERGE. Some may be worked out. - [Merge Statement Bypasses Referential Integrity](http://connect.microsoft.com/SQLServer/feedback/details/357419/merge-statement-bypasses-referential-integrity) - [Parameteri...

@Jeff, for what it's worth, I'm deeply disappointed with SQL Server's inability to (reliably? at all?) reuse the data from a CTE when it is referenced multiple times. I have worked with Oracle not much, but have done a couple of complicated queries usin...

@Jeff, for what it's worth, I'm deeply disappointed with SQL Server's inability to (reliably? at all?) reuse the data from a CTE when it is referenced multiple times. I have worked with Oracle not much, but have done a couple of complicated queries usin...

If you insert to the temp table, then select from it, I can't really see this being a huge resource hog. Even if the select is from a real table there just can't be that much performance improvement with the MERGE. The server has to put the rows into th...

If you insert to the temp table, then select from it, I can't really see this being a huge resource hog. Even if the select is from a real table there just can't be that much performance improvement with the MERGE. The server has to put the rows into th...

Yes, this only showed recent modifications from the last hour or so. It didn't show modifications from 8 - 10 hours ago....

Yes, this only showed recent modifications from the last hour or so. It didn't show modifications from 8 - 10 hours ago....

A simple method to find out who altered/modified an object in SQL server using trace. SELECT I.* FROM sys.traces T CROSS Apply ::fn_trace_gettable(T.path, T.max_files) I Join sys.trace_events E On I.eventclass = E.trace_event_i...

A simple method to find out who altered/modified an object in SQL server using trace. SELECT I.* FROM sys.traces T CROSS Apply ::fn_trace_gettable(T.path, T.max_files) I Join sys.trace_events E On I.eventclass = E.trace_event_i...