SQL SERVER – Regular Table or Temp Table – A Quick Performance Comparison

(Pinal Dave) Recently I received a very interesting question from my client who is a recently hired me for Comprehensive Database Performance Health Check. The question was a very simple but interesting one and I have decided to answer it with the proof and working demonstration.