Evil Kraig F (2/12/2012)
Koen Verbeeck (2/12/2012)
Nice question Craig, thanks!Thanks. I was concerned that I wouldn't explain the components well enough. Hopefully the scenario is clear and this doesn't end up as an anti-NOLOCK discussion instead of one regarding troubleshooting the differences between DELETE and TRUNCATE.
It is explained well enough - at least according to me - and the MSDN article linked to also explains it all.
Your question did say the end users decided they could live with incomplete or missing data, so an anti-lock discussion is not necessary: the DBA/report developer did his job in my opinion. He informed the users about the consequences and they accepted them.
Evil Kraig F (2/12/2012)
Also kind of surprised, this wasn't supposed to be available until tomorrrw. :hehe:
That's because is used DBCC_TIMEWARP to solve this question 😀 :hehe: 😉
Ok seriously now, in the weekend questions usually appear a few hours too early.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP