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

Posted in Database, Uncategorized | Tagged , , | Leave a comment

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

Posted in Database, Tool and Debug | Tagged , , | Leave a comment

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

Posted in Best Software Practices, Database | Tagged | Leave a comment