SQL Scripts Archives - Page 235 of 318 - SQL Authority with Pinal Dave

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

March 15, 2010

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

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…

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…

SQL SERVER – Order of Columns in Update Statement Does not Matter

March 5, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts

I recently received few comments that I have not written on simple subjects recently. In fact, this blog is dedicated to all those who are really learning SQL Server and almost all the articles and posts are posted here keeping this goal in mind. One of the questions in the…

SQL SERVER – Rollback TRUNCATE Command in Transaction

March 4, 2010

Pinal Dave

SQL Tips and Tricks

DML Operation, SQL Scripts, SQL Server, Transaction Log

This is a very common concept that truncate cannot be rolled back. Let us learn in today’s blog post that Rollback TRUNCATE is possible.

SQL SERVER – Performance Comparison – INSERT TOP (N) INTO Table – Using Top with INSERT

March 3, 2010

Pinal Dave

SQL Performance

SQL Index, SQL Scripts, SQL Server

Recently I wrote about SQL SERVER – INSERT TOP (N) INTO Table – Using Top with INSERT I mentioned about how TOP works with INSERT. I have mentioned that I will write about the performance in next article. Here is the performance comparison of the two options.