Archive for December, 2009
My Latest Photo
Recently my company required each of us taking photo. This is one of my photo. I feel nice with bokeh.
Posted via email from Ervin Ter’s posterous
Tips To Increase Performance of Store Procedure
1. NOCOUNTNormally if you perform query in Query Analyzer, it will return row count information in output. By default this NOCOUNT option is tuning OFF, it is advised to SET NOCOUNT ON to save overhead and increase performance.
2. NOLOCKThis will not lock your table and increase performance.
3. Return ValueIf you are querying about single value, [...]
