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

SQLAuthority News – PASS 2009 Sessions on Query Optimization and Performance Tuning

October 20, 2009

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

Best Practices, Database, MVP, SQL PASS, SQLAuthority Author Visit

PASS Summit 2009 is now only 10 days away and I am very excited for the same. I can not wait to attend the summit as this is the most awaited conference of SQL Server in world. Everybody will be there and there will be something for everybody. My core…

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…

SQLAuthority News – Whitepaper – Auditing in SQL Server 2008

October 18, 2009

Pinal Dave

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

SQL Documentation, SQL Download, SQL White Papers

Auditing in SQL Server 2008 SQL Server Technical Article Writer: Il-Sung Lee, Art Rask Technical Reviewer: Jack Richins, Rick Byham, Sameer Tejani, Al Comeau, JC Cannon Published: February 2009 With SQL Server Audit, SQL Server 2008 introduces an important new feature that provides a true auditing solution for enterprise customers.…

SQLAuthority News – Happy Diwali and New Year

October 17, 2009

Pinal Dave

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

I wish all of you Happy Diwali and New Year. Dīwali is a significant festival an official holiday in India. While Divali is popularly known as the “festival of lights”, the most significant spiritual meaning is “the awareness of the inner light”. Database tip of the day : Test your…

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…

SQLAuthority News – First Editorial – T-SQL Challenges Beginners

October 14, 2009

Pinal Dave

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

I would like to welcome all of you to very first editorial for T-SQL Challenges for Beginners. T-SQL Challenges began with the aim to help community to come out of regular mind set of just reading articles online. There is plenty of reading material available online, but there are very…

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.