Pinal Dave - SQL Server Performance Tuning Expert

SQLAuthority Author Visit – IT Outsourcing to India – Top 10 Reasons Companies Outsource

December 4, 2007

Database, DBA, Outsourcing Technology, Software Development, SQLAuthority Author Visit

Yesterday I had meeting with few of the leading outsourcing companies in Ahmedabad, India. Regular readers of this blog knows that I am currently in India handling large scale outsourcing assignment. My responsibilities includes managing application development, system architecture and database architecture. The purpose of meeting was to exchange the…

SQL SERVER – Grouping JOIN Clauses In SQL

December 3, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Joins

I always enjoy writing and reading articles about JOIN Clauses. One of my friend and the best ColdFusion Expert Ben Nadel has written good article about SQL JOINs. There are few interesting comments as well at the end of article. “JOIN grouping is pretty powerful and can get you out…

SQL SERVER – Q and A with Database Administrators

December 2, 2007

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks

Database, DBA, Software Development, SQLAuthority Author Visit

I have been in India for more than a month now, as I am leading a very large outsourcing project. We have conducted few interviews since the project required more Database Administrators and Senior Developers. I am listing few of the questions discussed during all the interviews. The whole event…

SQL SERVER – Sharpen Your Skills: Brush up on FILLFACTOR, ISNULL, NULLIF, and % as wildcard and operator

December 1, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Database, DBA

Read my article in SQL Server Magazine December 2007 Edition I will be not able to post complete article here due to copyright issues. Please visit the link above to read the article. [Articles are relocated so links are disabled] Reference : Pinal Dave (https://blog.sqlauthority.com)

SQLAuthority News – Download SQL Server 2005 Books Online (September 2007)

November 30, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Database, SQL Download

Download an updated version of Books Online for Microsoft SQL Server 2005. Books Online is the primary documentation for SQL Server 2005. The September 2007 update to Books Online contains new material and fixes to documentation problems reported by customers after SQL Server 2005 was released. Refer to “New and…

SQL SERVER – Database Interview Questions and Answers Complete List

November 29, 2007

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks

Data Warehousing, Database, DBA, Software Development

Update: I have updated this article series and newly updated article series is over here. If you are subscribed to my blog you will know that I receive request to send Database or SQL Server very frequently. Following is list of articles of my questions and answers series. Download SQL…

SQL SERVER – Correct Syntax for Stored Procedure SP

November 28, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL Stored Procedure

Just a day ago, I received interesting question about correct syntax for Stored Procedure. Many readers of this blog will think that it is very simple question. The reason this is interesting is the question behavior of BEGIN … END statements and GO command in Stored Procedure. Let us first…