Anil Singh | Code-sample.com

Stayed Informed – Best SQL Server Tutorials with Examples 1.       Try to use stored procedures instead of bulky queries. 2.       Try to avoid using temporary tables inside your stored procedures. 3.       Try to avoid using DDL statements inside your stored procedure. 4.       Try to use “ schema name ” with “ object name ”.  For examples as, n   SELECT * FROM [dbo] .[ Users] -- Preferred this method. Instead of below n   SELECT * FROM Users – Try to avoid this method. n   --For calling stored procedure with name like, n   EXEC  [ dbo] .[uspGetUser ] -- Preferred this method. n   --Instead of n   EXEC   uspGetUser  – Try to Avoid this method. 5.       Try to call stored procedures using their fully qualified name. For examples as, n   Use IF EXISTS ...