All Articles - SQL Authority with Pinal Dave

SQL SERVER – Interesting Observation – TOP 100 PERCENT and ORDER BY

November 24, 2009

Today we will go over a very simple, but interesting subject. The following error is quite common if you use ORDER BY while creating any view: Msg 1033, Level 15, State 1, Procedure something, Line 5 The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and…

SQL SERVER – A Common Design Problem – Should the Primary Key Always be a Clustered Index

November 23, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Constraint and Keys

In SQL Server, whenever we create any key, a Primary Key automatically creates clustered index on the same. I like this feature and I use this feature every now and then. The question is does the change of any column as Primary Key should also create a Clustered Index? Moreover,…

SQL SERVER – Remove Bookmark Key Lookup – 4 Different Ideas

November 22, 2009

Pinal Dave

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

SQL Index

I quite often get request to summarized my ideas about Removing bookmark lookup on this blog post. Bookmark lookup or key lookup are bad for any query as they force query engine to lookpup corresponding row in the table or index as it does not find required data from just…

SQLAuthority News – SQL Server 2008 for Oracle DBA

November 21, 2009

Pinal Dave

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

Database, DBA, MySQL, Oracle

This 15 modules, level 300 course provides students with the knowledge and skills to capitalize on their skills and experience as an Oracle DBA to manage a Microsoft SQL Server 2008 system. This workshop provides a quick start for the Oracle DBA to map, compare, and contrast the realm of…

SQLAuthority News – Book Review – Expert SQL Server 2008 Encryption by Michael Coles

November 20, 2009

Pinal Dave

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

SQL Server Encryption, SQLAuthority Book Review

Expert SQL Server 2008 Encryption (Paperback) Michael Coles (Author), Rodney Landrum (Author) Link to Amazon “What is your opinion on encryption? What I mean is: In a world filled with data, how do you see encryption?” This is the precise question Michael Coles posed to me on March 3rd of…

SQL SERVER – Understanding Table Hints with Examples

November 19, 2009

Pinal Dave

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

SQL Joins, SQL Scripts

Introduction Today we have a very interesting subject to look at. I tried to look for help online but have not found any other documentation besides what we have from the Book Online. Let us try to understand what are the different kinds of hints available in SQL Server and…

SQL SERVER – Size of Index Table – A Puzzle to Find Index Size for Each Index on Table

November 18, 2009

Pinal Dave

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

SQL Index, SQL Scripts, SQL Stored Procedure

It is very easy to find out some basic details of any table using the following Stored Procedure. USE AdventureWorks GO EXEC sp_spaceused [HumanResources.Shift] GO Above query will return following resultset The above SP provides basic details such as rows, data size in table, and Index size of all the…

SQL SERVER – 2005 2008 – Backup, Integrity Check and Index Optimization By Ola Hallengren

November 17, 2009

Pinal Dave

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

SQL Documentation, SQL Index

Script of Backup, Integrity Check and Index Optimization are the most important scripts for any developer. SQL Expert and true SQL enthusiast Ola Hallengren is known for his excellent scripts. Please try it out and let me know what you think. The documentation is available on http://ola.hallengren.com/Documentation.html and the script…

SQLAuthority News – Notes of Excellent Experience at SQL PASS 2009 Summit, Seattle

November 16, 2009

Pinal Dave

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

Database, DBA, MVP, SQL PASS

Update: Do not forget to checkout last three photos and follow me on twitter (of course!) I have previously documented my four-day experience of SQL PASS 2009 Summit at Seattle. There were many reasons for SQL enthusiasts to attend the SQL PASS event; I am listing my own reasons here…

SQL SERVER – Whitepaper Consolidation Using SQL Server 2008

November 15, 2009

Pinal Dave

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

SQL White Papers

Consolidation Using SQL Server 2008 Writer: Allan Hirt, Megahirtz LLC (allan@sqlha.com) Technical Reviewers: Lindsey Allen, Madhan Arumugam, Ben DeBow, Sung Hsueh, Rebecca Laszlo, Claude Lorenson, Prem Mehra, Mark Pohto, Sambit Samal, and Buck Woody Published: October 2009 Many companies are considering or have already implemented consolidation of computing resources, including…