All Articles - SQL Authority with Pinal Dave

SQL SERVER – FIX : Error : 3702 Cannot drop database because it is currently in use.

December 7, 2007

Msg 3702, Level 16, State 3, Line 2 Cannot drop database “DataBaseName” because it is currently in use. This is a very generic error when DROP Database is command is executed and the database is not dropped. The common mistake user is kept the connection open with this database and…

SQL SERVER – 2005 – Dynamic Management Views (DMV) and Dynamic Management Functions (DMF)

December 6, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL DMV, SQL Function

Dynamic Management Views (DMV) and Dynamic Management Functions (DMF) return server state information that can be used to monitor the health of a server instance, diagnose problems, and tune performance. They can exactly tell what is going on with SQL Server and its objects at the moment.There are tow kinds…

SQL SERVER – UDF – Remove Duplicate Chars From String

December 5, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Duplicate Records, SQL Function, SQL Scripts, SQL String

Few days ago, I received following wonderful UDF from one of this blog reader. This UDF is written for specific purpose of removing duplicate chars string from one large string. Virendra Chauhan, author of this UDF is working as DBA in Lutheran Health Network. CREATE FUNCTION dbo.REMOVE_DUPLICATE_INSTR (@datalen_tocheck INT,@string VARCHAR(255))…

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

December 4, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

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…