Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!

Plan Your Work

1. Have a clear idea about what you want to do is very important, especially when you are working on an explorative project. It often saves you time to …

Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!

1. 比如在 LEFT JOIN 中过滤条件写在 ON 和 WHERE 的区别。

2. Table-value function 和 scalar-valued function 的区别.

3. char、varchar、nvarchar之间的区别(包括 …

Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!

Performance

1. Avoid implicit data convertion! This might cause full table scan which hurts performance badly. For more discussions, please refer to 一条垃圾SQL，把 64 核 CPU 快 …

Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!