Viewing 4 posts - 76 through 79 (of 79 total)
The Inserts both execute at about the same speed. It is the "Select where not in" statement that is considerably slower with the table variable. So I think...
October 3, 2011 at 7:05 am
I haven't proven this correct yet, but I am thinking redundant data in two tables makes sense if you need that data to join the tables properly and avoid table/index...
April 20, 2011 at 7:29 am
I would argue that sometimes you may have redundant data in your database to make reporting easier and faster.
April 20, 2011 at 6:47 am
Things have certainly improved in my career from last year. I spent the last several years at one company that basically did an about-face and stopped taking its IT...
April 15, 2011 at 8:07 am