Lost your password?

Blogs about: Pinal Dave

Featured Blog

SQL SERVER - A Common Design Problem - Should the Primary Key Always be a Clustered Index1 comment

pinaldave wrote 3 hours ago: In SQL Server, whenever we create any key, a Primary Key automatically creates clustered index on th … more →

Tags: SQL, SQL Authority, SQL Constraint and Keys, SQL Query, SQL Server, SQL Tips and Tricks, SQLSERVER, T-SQL, technology

SQL SERVER - Remove Bookmark Key Lookup - 4 Different Ideas

pinaldave wrote 1 day ago: I quite often get request to summarized my ideas about Removing bookmark lookup on this blog post. B … more →

Tags: SQL, SQL Authority, SQL Index, SQL OPTIMIZATION, SQL Performance, SQL Query, SQL Server, SQL Tips and Tricks, SQLSERVER

SQLAuthority News - SQL Server 2008 for Oracle DBA

pinaldave wrote 2 days ago: This 15 modules, level 300 course provides students with the knowledge and skills to capitalize on t … more →

Tags: Database, dba, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority News, T-SQL

SQLAuthority News - Book Review - Expert SQL Server 2008 Encryption by Michael Coles1 comment

pinaldave wrote 3 days ago: Expert SQL Server 2008 Encryption (Paperback) Michael Coles (Author), Rodney Landrum (Author) Link t … more →

Tags: SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority Book Review, SQLAuthority News, SQLSERVER, T-SQL

SQL SERVER - Understanding Table Hints with Examples4 comments

pinaldave wrote 4 days ago: Introduction Today we have a very interesting subject to look at. I tried to look for help online bu … more →

Tags: SQL, SQL Authority, SQL Joins, SQL Performance, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T-SQL

SQL SERVER - Size of Index Table - A Puzzle to Find Index Size for Each Index on Table11 comments

pinaldave wrote 5 days ago: It is very easy to find out some basic details of any table using the following Stored Procedure. US … more →

Tags: Reader's question, SQL, SQL Authority, SQL Index, SQL Puzzle, SQL Query, SQL Scripts, SQL Server, SQL Stored Procedure

SQL SERVER - 2005 2008 - Backup, Integrity Check and Index Optimization By Ola Hallengren2 comments

pinaldave wrote 6 days ago: Script of Backup, Integrity Check and Index Optimization are the most important scripts for any deve … more →

Tags: SQL, SQL Authority, SQL Documentation, SQL Index, SQL OPTIMIZATION, SQL Performance, SQL Query, SQL Server, SQL Tips and Tricks

SQLAuthority News - Notes of Excellent Experience at SQL PASS 2009 Summit, Seattle7 comments

pinaldave wrote 1 week ago: Update: Do not forget to checkout last three photos and follow me on twitter (of course!) I have pre … more →

Tags: Database, dba, MVP, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority News

SQL SERVER - Policy Based Management - Create, Evaluate and Fix Policies

pinaldave wrote 1 week ago: Introduction This article will cover the most spectacular feature of SQL 2008 – Policy-based m … more →

Tags: Database, Software development, SQL, SQL Authority, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T-SQL

SQL SERVER - Disable CHECK Constraint - Enable CHECK Constraint4 comments

pinaldave wrote 1 week ago: Foreign Key and Check Constraints are two types of constraints that can be disabled or enabled when … more →

Tags: SQL, SQL Authority, SQL Constraint and Keys, SQL Index, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T-SQL

SQL Authority News - Training MS SQL Server 2005/2008 Query Optimization And Performance Tuning14 comments

pinaldave wrote 1 week ago: This is very short note announcing details about my course details for ‘MS SQL Server 2005/200 … more →

Tags: SQL, SQL Authority, SQL Index, SQL OPTIMIZATION, SQL Performance, SQL Query, SQL Server, SQL Tips and Tricks, SQL Training

SQL SERVER - Removing Key Lookup - Seek Predicate - Predicate - An Interesting Observation Related to Datatypes4 comments

pinaldave wrote 2 weeks ago: Recently, I have been working on Query Optimization project. While working on it, I found the follow … more →

Tags: SQL, SQL Authority, SQL Index, SQL OPTIMIZATION, SQL Performance, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks

SQL SERVER - Stored Procedure are Compiled on First Run - SP taking Longer to Run First Time5 comments

pinaldave wrote 2 weeks ago: During the PASS summit, one of the attendees asked me the following question. Why the Stored Procedu … more →

Tags: SQL, SQL Authority, SQL Interview Questions and Answers, SQL Query, SQL Scripts, SQL Server, SQL Stored Procedure, SQL Tips and Tricks, T-SQL

SQLAuthority News - Data Compression Strategy Capacity Planning and Best Practices

pinaldave wrote 2 weeks ago: The data compression feature in SQL Server 2008 helps compress the data inside a database, and it ca … more →

Tags: SQL, SQL Authority, SQL Data Storage, SQL Query, SQL Server, SQL Tips and Tricks, SQL White Papers, SQLAuthority News, T-SQL

SQLAuthority News - SQL PASS Summit, Seattle 2009 - Day 41 comment

pinaldave wrote 2 weeks ago: Fourth day was awesome! I had scheduled nearly 8 meetings with different groups of people today. It … more →

Tags: MVP, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority Visit, SQLAuthority News, T-SQL

SQLAuthority News - SQL PASS Summit, Seattle 2009 - Day 33 comments

pinaldave wrote 2 weeks ago: The third day at SQL PASS Summit was education + entertainment day for me. During the last 10 days, … more →

Tags: MVP, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority Visit, SQLAuthority News, T-SQL

SQLAuthority News - SQL PASS Summit, Seattle 2009 - Day 214 comments

pinaldave wrote 2 weeks ago: The second day of PASS started with very engaging and it started with an original game invented by S … more →

Tags: MVP, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority Visit, SQLAuthority News, T-SQL

SQLAuthority News - SQL PASS Summit, Seattle 2009 - Day 112 comments

pinaldave wrote 2 weeks ago: Day 1 at PASS was awesome. I usually write everything in detail when I have to cover any project. Th … more →

Tags: MVP, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority Visit, SQLAuthority News, T-SQL

SQLAuthority News - 3 Year Old Blog - PASS Summit 2009 - 10.5 Million Views13 comments

pinaldave wrote 3 weeks ago: This blog has reached a remarkable milestone. It is 3 years old today. So far, there have been more … more →

Tags: SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority Visit, SQLAuthority News, T-SQL, technology


Have your say. Start a blog.

See our free features →

Related Tags
All →

Follow this tag via RSS