SQL Performance Archives - Page 85 of 100 - SQL Authority with Pinal Dave

SQL SERVER – 2005 – Best Practices Analyzer (August 2008)

August 17, 2008

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

SQL Download, SQL Server Security, SQL Utility

The SQL Server 2005 Best Practices Analyzer (BPA) gathers data from Microsoft Windows and SQL Server configuration settings. BPA uses a predefined list of SQL Server 2005 recommendations and best practices to determine if there are potential issues in the database environment. This download is the August 2008 release of…

SQLAuthority News – Tip of the Minute

August 16, 2008

Pinal Dave

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

Best Practices, Database, DBA

Since my new personal website is launched I have received many comments and emails regarding new section of Tip of the Minute. Right navigation bar of the my personal website https://www.pinaldave.com/ contains section of the Tip of the Minute. Every time when page is refreshed it displays one new tip…

SQL SERVER – 2008 – Introduction to Online Indexing Operation

August 15, 2008

Pinal Dave

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

SQL Index, SQL Scripts, SQL Server

When index is created or recreated it usually decreases performance of database. Either SQL takes long time for response or it does not response at all as transactions are blocked. When new table or database goes live it is not possible to find out exactly how many indexes are needed.…

SQL SERVER – EXCEPT Clause in SQL Server is Similar to MINUS Clause in Oracle

August 7, 2008

Pinal Dave

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

SQL Joins, SQL Scripts

One of the JR. Developer asked me a day ago, does SQL Server has similar operation like MINUS clause in Oracle. Absolutely, EXCEPT clause in SQL Server is exactly similar to MINUS operation in Oracle. The EXCEPT query and MINUS query returns all rows in the first query that are…

SQL SERVER – 2005 – Difference Between INTERSECT and INNER JOIN – INTERSECT vs. INNER JOIN

August 3, 2008

Pinal Dave

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

SQL Joins, SQL Scripts

INTERSECT operator in SQL Server 2005 is used to retrieve the common records from both the left and the right query of the Intersect Operator. INTERSECT operator returns almost same results as INNER JOIN clause many times. When using INTERSECT operator the number and the order of the columns must…

SQL SERVER – Effect of Order of Join In Query

August 2, 2008

Pinal Dave

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

SQL Index, SQL Joins, SQL Scripts, SQL Server

Let us try to understand this subject with example. We will use Adventurworks database for this purpose. Table which we will be using are HumanResources.Employee (290 rows), HumanResources.EmployeeDepartmentHistory (296 rows) and HumanResources.Department (16 rows). We will be running following two queries and observe the output. In the resultset the order…

SQL SERVER – DBCC SHRINKFILE Takes Long Time to Run

July 25, 2008

Pinal Dave

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

SQL Server DBCC

If you are DBA who are involved with Database Maintenance and file group maintenance, you must have experience that many times DBCC SHRINKFILE operations takes long time but any other operations with Database are relative quicker. Rebuilding index is quite resource intensive task but that happens faster than DBCC SHRINKFILE.…