Category: Database Design & Architecture

Best practices for Stored Procedures in SQL Server

Read the following blog post for Best Practices to be followed for designing the tables in SQL Server. Best practices for designing tables in SQL Server SET NOCOUNT ON should be there at the beginning of Stored Procedure. SET TRANSATION ISOLATION LEVEL READ UNCOMMITED should be there at the beginning of Stored Procedure unless you … Continue reading Best practices for Stored Procedures in SQL Server

Decoupling vs Performance – SQL Server

Did you ever noticed thousands of lines of code in a single¬†Stored Procedure? Did you faced performance issues in such Stored Procedure? Did you faced difficulties in debugging such Stored Procedure? Did you ever noticed the millions and billions of rows in a single Table? Did you faced the difficulties¬†and performance issues in dealing with … Continue reading Decoupling vs Performance – SQL Server