June 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

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