Blogs about: Pinal Dave
Featured Blog
Congratulations Pinal Dave!
In the recently concluded MVP Summit, Pinal Dave was named one of the Top Contributors in SQL Server community. His blog is really a great source for SQL Server. I believe his blog is second only to M… more →
Marlon Ribunal's Note On SQL Server
SQL SERVER - A Common Design Problem - Should the Primary Key Always be a Clustered Index
— 1 comment
pinaldave wrote 3 hours ago: In SQL Server, whenever we create any key, a Primary Key automatically creates clustered index on th … more →
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 →
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 →
SQLAuthority News - Book Review - Expert SQL Server 2008 Encryption by Michael Coles
— 1 comment
pinaldave wrote 3 days ago: Expert SQL Server 2008 Encryption (Paperback) Michael Coles (Author), Rodney Landrum (Author) Link t … more →
SQL SERVER - Understanding Table Hints with Examples
— 4 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 →
SQL SERVER - Size of Index Table - A Puzzle to Find Index Size for Each Index on Table
— 11 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 →
SQL SERVER - 2005 2008 - Backup, Integrity Check and Index Optimization By Ola Hallengren
— 2 comments
pinaldave wrote 6 days ago: Script of Backup, Integrity Check and Index Optimization are the most important scripts for any deve … more →
SQLAuthority News - Notes of Excellent Experience at SQL PASS 2009 Summit, Seattle
— 7 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 →
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 →
SQL SERVER - Disable CHECK Constraint - Enable CHECK Constraint
— 4 comments
pinaldave wrote 1 week ago: Foreign Key and Check Constraints are two types of constraints that can be disabled or enabled when … more →
SQL Authority News - Training MS SQL Server 2005/2008 Query Optimization And Performance Tuning
— 14 comments
pinaldave wrote 1 week ago: This is very short note announcing details about my course details for ‘MS SQL Server 2005/200 … more →
SQL SERVER - Removing Key Lookup - Seek Predicate - Predicate - An Interesting Observation Related to Datatypes
— 4 comments
pinaldave wrote 2 weeks ago: Recently, I have been working on Query Optimization project. While working on it, I found the follow … more →
SQL SERVER - Stored Procedure are Compiled on First Run - SP taking Longer to Run First Time
— 5 comments
pinaldave wrote 2 weeks ago: During the PASS summit, one of the attendees asked me the following question. Why the Stored Procedu … more →
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 →
SQLAuthority News - SQL PASS Summit, Seattle 2009 - Day 4
— 1 comment
pinaldave wrote 2 weeks ago: Fourth day was awesome! I had scheduled nearly 8 meetings with different groups of people today. It … more →
SQLAuthority News - SQL PASS Summit, Seattle 2009 - Day 3
— 3 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 →
SQLAuthority News - SQL PASS Summit, Seattle 2009 - Day 2
— 14 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 →
SQLAuthority News - SQL PASS Summit, Seattle 2009 - Day 1
— 12 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 →
SQLAuthority News - 3 Year Old Blog - PASS Summit 2009 - 10.5 Million Views
— 13 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 →
