SQL Tips and Tricks Archives - Page 428 of 536 - SQL Authority with Pinal Dave

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

February 8, 2009

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

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…