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

SQL SERVER – Index Reorganize or Index Rebuild

February 15, 2008

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

Recently, I have received one question quite often about when to Index Reorganize and when to Index Rebuild. I have already written about this topic earlier but it seems that many are unable to search it. SQL SERVER – Difference Between Index Rebuild and Index Reorganize Explained with T-SQL Script…

SQL SERVER – Introduction to Performance Monitor – How to Use Perfmon

February 14, 2008

Pinal Dave

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

SQL Utility

Yesterday I wrote about SQL SERVER – Introduction to Three Important Performance Counters. I received few questions about how to use Perfmon. Here is very brief introduction to Perfmon. There are three ways to launch Perfmon. 1) Type “start perfmon” at the command prompt. 2) Go to Start | Programs…

SQL SERVER – Introduction to Three Important Performance Counters

February 13, 2008

Pinal Dave

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

SQL Utility

Performance Counters are very important to evaluate. There are more than thousands of Performance Counters. Today I will cover three basic but very important Performance Counters. Processor:% Processor Time It reports the total processor time with respect to the available capacity of the server. If counter is between 50 to…

SQL SERVER – 2005 – Find Unused Indexes of Current Database

February 11, 2008

Pinal Dave

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

SQL Index, SQL Scripts

Simple but accurate following script will give you list of all the indexes in the database which are unused. If indexes are not used they should be dropped as Indexes reduces the performance for INSERT/UPDATE statement. Indexes are only useful when used with SELECT statement. Script to find unused Indexes.…

SQL SERVER – Time Out Due to Executing DELETE on Large RecordSet

January 14, 2008

Pinal Dave

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

SQL Scripts

Just a day ago, I received following question: “I have large table more than 1M rows. I want to delete every row in my table. Everytime I ran DELETE statement, it times out and does not do it job. The data in table is useless and I do not need…

SQL SERVER – 2005 – Display Fragmentation Information of Data and Indexes of Database Table

January 10, 2008

Pinal Dave

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

SQL DMV, SQL Index, SQL Scripts, SQL Server DBCC, SQL System Table

One of my friend involved with large business of medical transcript invited me for SQL Server improvement talk last weekend. I had great time talking with group of DBA and developers. One of the topic which was discussed was how to find out Fragmentation Information for any table in one…

SQL SERVER – Execute Same Query and Statement Multiple Times Using Command GO

January 9, 2008

Pinal Dave

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

SQL DateTime, SQL Scripts

Following question was asking by one of long time reader who really liked trick of SQL SERVER – Explanation SQL Command GO and SQL SERVER – Insert Multiple Records Using One Insert Statement – Use of UNION ALL. She asked how can I execute same code multiple times without Copy…