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

SQL SERVER – 2005 – Explanation and Script for Online Index Operations – Create, Rebuild, Drop

August 17, 2007

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

SQL Server 2005 Enterprise Edition supports online index operations. Index operations are creating, rebuilding and dropping indexes. The question which I receive quite often – what is online operation? Is online operation is related to web, internet or local network? Online operation means when online operations are happening the database…

SQL SERVER – Insert Data From One Table to Another Table – INSERT INTO SELECT – SELECT INTO TABLE

August 15, 2007

Pinal Dave

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

SQL Scripts, SQL Stored Procedure

Following three questions are many times asked on this blog. How to insert data from one table to another table efficiently? How to insert data from one table using where condition to another table? How can I stop using cursor to move data from one table to another table? There…

SQLAuthority News – Author Visit – Database Architecture and Implementation Discussion – New York, New Jersey Details

August 13, 2007

Pinal Dave

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

DBA, SQL Backup and Restore, SQL Index, SQLAuthority Author Visit

Last weekend I visited New York City (NY) and Edison (NJ) to attend database architecture meeting with a big environmental technology firm. It was very interesting to meet CEO and few of the lead database administrators. Lots of database related things were discussed. I will list few of the points…

SQL SERVER – 2005 – SSMS – View/Send Query Results to Text/Grid/Files

July 19, 2007

Pinal Dave

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

SQL Download, SQL Error Messages, SQL Joins, SQL Scripts, SQL Server DBCC, SQL Server Security

Many times I have been asked how to change the result window from Text to Grid and vice versa. There are three different ways to do it. Method 1 : Key-Board Short Cut Results to Text – CTRL + T Results to Grid – CTRL + D Results to File…

SQL SERVER – CASE Statement in ORDER BY Clause – ORDER BY using Variable

July 17, 2007

Pinal Dave

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

SQL Function, SQL Scripts

This article is as per request from Application Development Team Leader of my company. His team encountered code where application was preparing string for ORDER BY clause of SELECT statement. Application was passing this string as variable to Stored Procedure (SP) and SP was using EXEC to execute the SQL…

SQL SERVER – Microsoft White Papers – Analysis Services Query Best Practices – Partial Database Availability

July 16, 2007

Pinal Dave

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

Best Practices, SQL Download, SQL White Papers

Microsoft TechNet frequently releases White Papers on SQL Server Technology. I have read the following two white papers recently. The summary of its content is here. Analysis Services Query Performance Top 10 Best Practices Optimize cube and measure group design Define effective aggregations Use partitions Write efficient MDX Use the…

SQL SERVER – 2005 – Features Comparison Chart

July 11, 2007

Pinal Dave

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

SQL Download

This post in the response to all the readers who have asked what are the differences between SQL Server 2005 editions. The reason I have never posted article about this as Microsoft has wonderful comparison chart on Microsoft SQL Server web site. This chart explains the difference between features of…