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

SQL SERVER – Difference Between Candidate Keys and Primary Key In Simple Words

October 22, 2009

Introduction Not long ago, I had an interesting and extended debate with one of my friends regarding which column should be primary key in a table. The debate instigated an in-depth discussion about candidate keys and primary keys. My present article revolves around the two types of keys. Let us…

SQL SERVER – Change Collation of Database Column – T-SQL Script – Consolidating Collations – Extention Script

October 19, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Collation, SQL Scripts, SQL Utility

This document is created by Brian Cidern, he has written this excellent extension to SQL Expert who SQL SERVER – Change Collation of Database Column – T-SQL Script. His scripts are not only extremely helpful to achieve the task of consolidating collations in quick script. His script not only works…

SQL SERVER – Recently Executed T-SQL Query

October 16, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL DMV, SQL Function, SQL Scripts, SQL System Table

About a year ago, I wrote blog post about SQL SERVER – 2005 – Last Ran Query – Recently Ran Query. Since, then I have received many question regarding how this is better than fn_get_sql() or DBCC INPUTBUFFER. The Short Answer in is both of them will be deprecated. Please…

SQL SERVER – Enable Automatic Statistic Update on Database

October 15, 2009

Pinal Dave

SQL Performance

SQL Scripts, SQL Server, SQL Statistics

In one of the recent projects, I found out that despite putting good indexes and optimizing the query, I could not achieve an optimized performance and I still received an unoptimized response from the SQL Server. On examination, I figured out that the culprit was statistics. The database that I was trying to optimize had auto update of the statistics was disabled. Let us learn about how to Enable Automatic Statistic Update on Database.

SQL SERVER – Query Optimization – Remove Bookmark Lookup – Remove RID Lookup – Remove Key Lookup – Part 3

October 12, 2009

Pinal Dave

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

SQL Index, SQL Scripts, SQL Server

Earlier I have written two different articles on the subject Remove Bookmark Lookup. This article is as part 3 of the original article. Please read the first two articles here before continuing reading this article.

SQL SERVER – Queries Waiting for Memory Allocation to Execute

October 9, 2009

Pinal Dave

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

SQL Memory, SQL Scripts

In one of the recent projects, I was asked to create a report of queries that are waiting for memory allocation. The reason was that we were doubtful regarding whether the memory was sufficient for the application. The following query can be useful in similar case. Queries that do not…

SQL SERVER – Query Optimization – Remove Bookmark Lookup – Remove RID Lookup – Remove Key Lookup – Part 2

October 8, 2009

Pinal Dave

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

SQL Index, SQL Scripts

This article is follow up of my previous article SQL SERVER – Query Optimization – Remove Bookmark Lookup – Remove RID Lookup – Remove Key Lookup. Please do read my previous article before continuing further. I have described there two different methods to reduce query execution cost. Let us compare…