Feeds:
Posts
Comments

Archive for the ‘SQL Scripts’ Category

SQL SERVER – Difference Between ROLLBACK IMMEDIATE and WITH NO_WAIT during ALTER DATABASE

Posted in Pinal Dave, SQL, SQL Authority, SQL Documentation, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology on March 17, 2010 | 2 Comments »

Today, we are going to discuss about something very simple, but quite commonly confused two options of ALTER DATABASE.
The first one is ALTER DATABASE …ROLLBACK IMMEDIATE and the second one is WITH NO_WAIT.
Many people think they are the same or are not sure of the difference between these two options. Before we continue our explaination, [...]

Read Full Post »

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

Posted in Pinal Dave, Readers Question, SQL, SQL Authority, SQL Performance, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, SQLServer, T SQL, Technology, tagged on March 15, 2010 | 4 Comments »

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 of CPUs in a single [...]

Read Full Post »

SQL SERVER – Checklist for Analyzing Slow-Running Queries

Posted in Pinal Dave, SQL, SQL Authority, SQL Index, SQL Optimization, SQL Performance, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology on March 12, 2010 | 3 Comments »

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 quick search on my saved [...]

Read Full Post »

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

Posted in Pinal Dave, Readers Question, SQL, SQL Authority, SQL Index, SQL Optimization, SQL Performance, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology on March 11, 2010 | 3 Comments »

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 does seek operation; how can I convert [...]

Read Full Post »

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

Posted in Pinal Dave, SQL, SQL Authority, SQL Index, SQL Optimization, SQL Performance, SQL Puzzle, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology, tagged on March 9, 2010 | 21 Comments »

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 is a very complex subject and [...]

Read Full Post »

Older Posts »