Thomas,

I like the technique with partition switching. Thank you.

BTW, for your method 2, you will need

SET IDENTITY_INSERT Destination_TB ON;

before the insert.

\Sean

Another technique we use to disable the so called "parameter sniffing" instead of WITH RECOMPILE is to declare local variables to replace the parameters immediately inside the stored procedure. ...

Thank you for bringing up this important PM topic. Transparency is essential for IT survival. We are engaged in a 18-month project re-enginerring our processing model from SAS...

I totally agree with Alan Robbins. .Net framework is powerful, solid and beautiful. Hosting CLR in SQL Server brings the core of .Net to us SQL developers and...