July 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQL SERVER – Pre-Code Review Tips – Tips For Enforcing Coding Standards

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Database, DBA, SQL Coding Standards, SQL Scripts
Each organization has its own coding standards and enforcement rules. It is sometime difficult for DBAs to change the code following code review, as it may affect many different layers of the application. In large organizations, many stored procedures are written and modified every day. It is smart to keep…
Read More

SQL SERVER – Difference Between EXEC and EXECUTE vs EXEC() – Use EXEC/EXECUTE for SP always

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
DBA, SQL Cursor, SQL Scripts, SQL Stored Procedure
What is the difference between EXEC and EXECUTE? They are the same. Both of them executes stored procedure when called as EXEC sp_help GO EXECUTE sp_help GO I have seen enough times developer getting confused between EXEC and EXEC(). EXEC command executes stored procedure where as EXEC() function takes dynamic…
Read More

SQLAuthority News – Job Opportunity in Ahmedabad, India to Work with Technology Leaders Worldwide

Pinal Dave
SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks, SQLAuthority News
Database, DBA, SQL Download, SQL Jobs
If you have one or more years of experience in any web based programming language (.NET, ColdFusion, PHP) and interested in SQL Server as well willing to locate Ahmadabad, India. Please send me your resume, if selected you may get chance to work with one of the most progressing industry…
Read More