Monthly Archives: March 2016
Use ScriptDom to Parse SQL Script
Microsoft provides a ScriptDom library that you can use to parse T-SQL script. It can be used with any CLR languages to quickly write your own SQL parser. This blog uses c# in its examples. Installation First, you need to … Continue reading
Show Query Statistics in SSMS
You can turn on the statistics before executing your SQL statement. In SSMS, you can do This output the time and io statistics to the Messages tab. And you can correlate the numbers to the Execution Plan output the check … Continue reading
How to Avoid Accidentally Update All Rows
Here are just some thoughts on preventing this problem: Before sql submitted to be executed Peer Code review: Although it may be not necessary to fully review the details, a quick review can at least catch some blunt errors such … Continue reading
SW Notes 