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

SQL SERVER – Generate Report for Index Physical Statistics – SSMS

March 26, 2010

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

SQL Index, SQL Server Management Studio, SQL Utility

Few days ago, I wrote about SQL SERVER – Out of the Box – Activity and Performance Reports from SSSMS (Link). A user asked me a question regarding if we can use similar reports to get the detail about Indexes. Yes, it is possible to do the same. There are…

SQL SERVER – Out of the Box – Activity and Performance Reports from SSSMS

March 25, 2010

Pinal Dave

SQL Performance

SQL Reports, SQL Server, SQL Server Management Studio

SQL Server management Studio 2008 is a wonderful tool and has many different features. Many times, an average user does not use them as they are not aware about these features. Today, we will learn one such feature. SSMS comes with many inbuilt performance reports and activity reports, but we do not use it to the full potential.

SQL SERVER – MAXDOP Settings to Limit Query to Run on Specific CPU

March 15, 2010

Pinal Dave

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

SQL Scripts

This is very simple and known tip. Query Hint MAXDOP – Maximum Degree Of Parallelism can be set to restrict query to run on a certain CPU. Please note that this query cannot restrict or dictate which CPU to be used, but for sure, it restricts the usage of number…

SQLAuthority News – Interesting Whitepaper – We Loaded 1TB in 30 Minutes with SSIS, and So Can You

March 14, 2010

Pinal Dave

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

Business Intelligence, SQL White Papers, SSIS

We Loaded 1TB in 30 Minutes with SSIS, and So Can You SQL Server Technical Article Writers: Len Wyatt, Tim Shea, David Powell Published: March 2009 In February 2008, Microsoft announced a record-breaking data load using Microsoft SQL Server Integration Services (SSIS): 1 TB of data in less than 30…

SQL SERVER – Checklist for Analyzing Slow-Running Queries

March 12, 2010

Pinal Dave

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

SQL Index, SQL Scripts

I am recently working on upgrading my class Microsoft SQL Server 2005/2008 Query Optimization and & Performance Tuning with additional details and more interesting examples. While working on slide deck I realized that I need to have one solid slide which talks about checklist for analyzing slow running queries. A…

SQL SERVER – Force Index Scan on Table – Use No Index to Retrieve the Data – Query Hint

March 11, 2010

Pinal Dave

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

SQL Index, SQL Scripts

Recently I received the following two questions from readers and both the questions have very similar answers. Question 1: I have a unique requirement where I do not want to use any index of the table; how can I achieve this? Question 2: Currently my table uses clustered index and…

SQL SERVER – Improve Performance by Reducing IO – Creating Covered Index

March 9, 2010

Pinal Dave

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

SQL Index, SQL Scripts

This blog post is in the response of the T-SQL Tuesday #004: IO by Mike Walsh. The subject of this month is IO. Here is my quick blog post on how Cover Index can Improve Performance by Reducing IO. Let us kick off this post with disclaimers about Index. Index…