This article is the part of Does it matter ? series.
This article includes set of 40 recommendations for stored procedures. Following checklist can be used by Developers during development of stored procedure. Leads can refer this checklist for review of the stored procedure submitted for code review. This checklist can also come handy to Database Developers and Administrators while working on Performance Tuning/Optimization of stored … Continue reading Best practices for Stored Procedures in SQL Server
Many a times we have requirements to check existence of a particular value in a particular table. There could be several ways to accomplish it viz. using left join and sub-query. All of us know that sub-queries are not optimized way while dealing with large volume of data. So what is the alternative to the Left Join which could also cause performance … Continue reading EXISTS() and NOT EXISTS()
Best practices for tables in SQL Server