How to use NOT IN, LEFT JOIN, EXCEPT and NOT EXIST effectively

Microsoft SQL Server provides a lot of statements to find what data is existed in A set but not in B set such as NOT IN, LEFT JOIN, EXCEPT and NOT EXISTS. The question is when we use these statements and which is the best performance in case we execute it on a large data set. In … Continue reading How to use NOT IN, LEFT JOIN, EXCEPT and NOT EXIST effectively

Advertisements

TSQL: How to delete large volume data quickly

A couple of weeks, my friends asked me the best suitable approach to move data out a large table. I was interested in this question because there was no right answers. Depending on the situation, environment even database structure to determine what approaches. Actually, there are a lot of techniques you can apply how to delete data … Continue reading TSQL: How to delete large volume data quickly