June 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

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 – Book Review – SQL Server 2005 DBA Street Smarts: A Real World Guide to SQL Server 2005 Certification Skills

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
SQLAuthority Book Review
SQL Server 2005 DBA Street Smarts: A Real World Guide to SQL Server 2005 Certification Skills (Paperback) by Joseph L. Jorden Link to Amazon Short Review: Microsoft’s new generation of certifications is design not only to emphasize your proficiency with a specific technology but also to prove you have the…
Read More

SQL SERVER – 2005 – White Paper – Integrating Visio 2007 and Microsoft SQL Server 2005

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Download, SQL Utility, SQL White Papers
This article focuses on integration techniques specific to Microsoft Office Visio 2007 and Microsoft SQL Server 2005. Using Visio 2007, you can connect Visio shapes to data that was generated outside Visio. A large amount of data can be captured in a SQL Analysis Services database. Being able to analyze…
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

SQL SERVER – Correlated and Noncorrelated – SubQuery Introduction, Explanation and Example

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Joins, SQL Scripts, SQL Sub Query
A correlated subquery is an inner subquery which is referenced by the main outer query such that the inner query is considered as being executed repeatedly. Example: ----Example of Correlated Subqueries USE AdventureWorks; GO SELECT e.EmployeeID FROM HumanResources.Employee e WHERE e.ContactID IN ( SELECT c.ContactID FROM Person.Contact c WHERE MONTH(c.ModifiedDate)…
Read More