Pinal Dave - SQL Server Performance Tuning Expert

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

March 13, 2008

Following error is very generic error and I have previously written SQL SERVER – FIX : Error : 3702 Cannot drop database because it is currently in use. Msg 3702, Level 16, State 3, Line 2 Cannot drop database “DataBaseName” because it is currently in use. One of the reader…

SQL SERVER – 2005 – Find Nth Highest Record from Database Table – Using Ranking Function ROW_NUMBER

March 12, 2008

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

MVP, SQL Function, SQL Joins, SQL Scripts

I have previously written SQL SERVER – 2005 – Find Nth Highest Record from Database Table where I have shown query to find 4th highest record from database table. Everytime when I write blog I am always very eager to read comments of readers. Some of regular readers are industry…

SQL SERVER – How to Retrieve TOP and BOTTOM Rows Together using T-SQL – Part 3

March 11, 2008

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

SQL Function, SQL Joins, SQL Scripts

Please read SQL SERVER – How to Retrieve TOP and BOTTOM Rows Together using T-SQL before continuing this article. I had asked users to come up with alternate solution of the same problem. Khadar Khan came up with good solution using CTE SQL SERVER – How to Retrieve TOP and…

SQL SERVER – How to Retrieve TOP and BOTTOM Rows Together using T-SQL – Part 2 – CTE

March 10, 2008

Pinal Dave

SQL Tips and Tricks

CTE, SQL Function, SQL Joins, SQL Scripts, SQL Server

Please read SQL SERVER – How to Retrieve TOP and BOTTOM Rows Together using T-SQL before continuing this article. I had asked users to come up with an alternate solution of the same problem. In this blog post we will see solution with the help of CTE.

SQLAuthority News – Authors Most Visited Article on Blog

March 9, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

SQL Stored Procedure, SQL Utility

I received many emails regarding SQLAuthority News – 500th Post – An Interesting Journey with SQL Server. One of the email asked interesting question regarding my most visited article on this blog. It was interesting to know that reader wants to know which article I visit the most. Following is…

SQL SERVER – Find Nth Highest Record from Database Table

March 8, 2008

Pinal Dave

SQL Tips and Tricks

SQL Function, SQL Scripts, SQL Server

I had previously written SQL SERVER – Query to Retrieve the Nth Maximum value. I just received an email that if I can write this using AdventureWorks database as it is a default sample database for SQL Server 2005 and the user can run the query against it and understand it better. Let us see how we can find highest record from database.

SQLAuthority News – 500th Post – An Interesting Journey with SQL Server

March 7, 2008

Pinal Dave

Personal, SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

Database, DBA, Software Development, SQLAuthority Author Visit

I am very pleased to write my 500th post. After 500 posts, I still have same feeling when I wrote first post on this blog. I would like to thank my family for their continuous support in writing this blog. Most of all I want to thank all of YOU…