SQL Archives - Page 415 of 519 - SQL Authority with Pinal Dave

SQL SERVER – Start SQL Server Instance in Single User Mode

February 10, 2009

SQL Scripts, SQL Server Management Studio, SQL Server Security, SQL Utility

There are certain situation when user wants to start SQL Server Engine in “single user” mode from the start up. To start SQL Server in single user mode is very simple procedure as displayed below. Go to SQL Server Configuration Manager and click on SQL Server 2005 Services. Click on…

SQL SERVER – 2008 – Download Microsoft SQL Server 2008 Express with Tools Free

February 9, 2009

Pinal Dave

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

Database, SQL Download, SQL Server Express, SQL Utility

Note: Download Microsoft SQL Server 2008 Express with Tools Free by Microsoft SQL Server 2008 Express Edition was much awaited version of SQL Server 2008. It is FREE and available to download from web. Microsoft SQL Server 2008 Express with Tools (SQL Server 2008 Express) is a free, easy-to-use version…

SQL SERVER – Introduction to Force Index Query Hints – Index Hint – Part2

February 8, 2009

Pinal Dave

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

SQL Constraint and Keys, SQL Index, SQL Scripts

In my previous article SQL SERVER – Introduction to Force Index Query Hints – Index Hint I have discussed regarding how we can use Index Hints with any query. I just received email from one of my regular reader that are there any another methods for the same as it…

SQL SERVER – Introduction to Force Index Query Hints – Index Hint

February 7, 2009

Pinal Dave

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

SQL Constraint and Keys, SQL Index, SQL Scripts

This article, I will start with disclaimer instead of having it at the end of article. “SQL Server query optimizer selects the best execution plan for a query, it is recommended to use query hints by experienced developers and database administrators in case of special circumstances.” When any query is…

SQL SERVER – Quickest Way to – Kill All Threads – Kill All User Session – Kill All Processes

February 6, 2009

Pinal Dave

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

SQL Scripts, SQL Utility

More than a year ago, I wrote how to kill all the processes running in SQL Server. Just a day ago, I found the quickest way to kill the processes of SQL Server. While searching online I found very similar methods to my previous method everywhere. Today in this article,…

SQLAuthority News – Two Promotion to Help Community

February 5, 2009

Pinal Dave

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

Microsoft Certifications, SQL Jobs

In this difficult time of recession I have two promotion to share with SQL Server community. 1) Discount on Microsoft Exams and Free Second Retake Due to bad job market, the ratio to available jobs to available candidates is lower than usual. Microsoft exams are key to stand up in…

SQL SERVER – Observation – Effect of Clustered Index over Nonclustered Index

February 4, 2009

Pinal Dave

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

SQL Constraint and Keys, SQL Index, SQL Scripts

Today I came across very interesting observation while I was working on query optimization. Let us run the example first. Make sure to to enable Execution Plan (Using CTRL + M) before running comparison queries. USE [AdventureWorks] GO /* */ CREATE TABLE [dbo].[MyTable]( [ID] [int] NOT NULL, [First] [nchar](10) NULL,…