All Articles - SQL Authority with Pinal Dave

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

February 6, 2009

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

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,…

SQLAuthority News – Download SQL Server 2008 System Views Poster – PDF – A Wall Poster

February 3, 2009

Pinal Dave

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

Best Practices, Database, SQL Download

Microsoft has published SQL Server 2008 System Views Poster. This poster should be must have poster for any SQL Server Developer. I have this poster on my wall. If you have extra copy of this postered in print. Do send it to me and I will forward it to developer…

SQL SERVER – T-SQL Script for FizzBuzz Logic

February 2, 2009

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Puzzle, SQL Server, SQL Tips and Tricks

SQL Scripts

Following is quite common Interview Question asked in many interview questions. FizzBuzz is popular but very simple puzzle and have been very popular to solve. FizzBuzz problem can be attempted in any programming language. Let us attempt it in T-SQL. Definition of FizzBuzz Puzzle : Write a program that prints…

SQLAuthority News – Download Microsoft SQL Server 2008 Books Online (January 2009)

February 1, 2009

Pinal Dave

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

Database, SQL Download

SQL Server 2008, the latest release of Microsoft SQL Server, provides a comprehensive data platform. Books Online is the primary documentation for SQL Server 2008. Books Online includes the following types of information: Setup and upgrade instructions. Information about new features and backward compatibility. Conceptual descriptions of the technologies and…

SQL SERVER – FIX : ERROR : Msg 5834, Level 16, State 1, Line 1 The affinity mask specified conflicts with the IO affinity mask specified. Use the override option to force this configuration

January 31, 2009

Pinal Dave

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

SQL Error Messages, SQL Index, SQL Scripts, SQL Stored Procedure

Yesterday I came across following error while enabling fill factor for my database server, when I was trying to write article SQL SERVER – 2008 – 2005 – Rebuild Every Index of All Tables of Database – Rebuild Index with FillFactor. I ran following T-SQL script and it gave me…

SQL SERVER – 2008 – 2005 – Rebuild Every Index of All Tables of Database – Rebuild Index with FillFactor

January 30, 2009

Pinal Dave

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

SQL Cursor, SQL Index, SQL Scripts

I just wrote down following script very quickly for one of the project which I am working on. The requirement of the project was that every index existed in database should be rebuilt with fillfactor of 80. One common question I receive why fillfactor 80, answer is I just think…

SQLAuthority News – Microsoft Certification Exam – Discount Code – Free Second Chance – MCTS, MCITP, MCPD

January 29, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Microsoft Certifications, MVP

Please note down this important code or share with your colleagues who are keen to take Microsoft Certification Exam. This unique code is only available through Microsoft MVP’s and only published here to help community and no other intention. In this challenging economic climate, upgrading your IT skills becomes crucial…

SQL SERVER – Generate A Single Random Number for Range of Rows of Any Table – Very interesting Question from Reader

January 28, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function, SQL Random, SQL Scripts

Just a day ago I received email from reader how to get single random number for range of rows of any table. The question was not very clear to me so I had asked him to send me question in simpler words. He sent me question back in simple words.…