Blogs about: Pinal Dave
SQL SERVER - Policy Based Management - Create, Evaluate and Fix Policies
pinaldave wrote 2 days 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 3 days 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 5 days 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
— 2 comments
pinaldave wrote 6 days 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
— 4 comments
pinaldave wrote 1 week 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 1 week 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
pinaldave wrote 1 week 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
— 2 comments
pinaldave wrote 1 week 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
— 13 comments
pinaldave wrote 1 week 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
— 9 comments
pinaldave wrote 1 week 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 1 week ago: This blog has reached a remarkable milestone. It is 3 years old today. So far, there have been more … more →
SQL Authority News - Advanced T-SQL with Itzik Ben-Gan - Solid Quality Mentors
— 3 comments
pinaldave wrote 2 weeks ago: As mentioned earlier in a blog post SQL SERVER – Advanced T-SQL with Itzik Ben-Gan – A Dream Coming … more →
SQLAuthority News - New PASS President Rushabh Mehta
— 13 comments
pinaldave wrote 2 weeks ago: The Professional Association for SQL Server (PASS) is an independent, not-for-profit association, de … more →
SQLAuthority News - India Market and Third Party SQL Server Tools
— 18 comments
pinaldave wrote 2 weeks ago: Last week, I had wonderful time attending meeting of small ISV (Independent Software Vendors). Sever … more →
SQLAuthority News - Birds-of-a-Feather (BOF) Lunch - SQL PASS Summit, Seattle, 2009
— 1 comment
pinaldave wrote 2 weeks ago: I received few emails regarding where can people meet me at SQL PASS event in Seattle. I am currentl … more →
SQL SERVER - How to Enable Index - How to Disable Index - Incorrect syntax near 'ENABLE'
— 4 comments
pinaldave wrote 2 weeks ago: Many times I have seen that the index is disabled when there is large update operation on the table. … more →
SQL SERVER - Advanced T-SQL with Itzik Ben-Gan - A Dream Coming True
— 11 comments
pinaldave wrote 2 weeks ago: As from my blog posts, all of you are probably aware that I am very much excited for attending SQL P … more →
SQLAuthority News - PASS Sessions - I will be there!
— 3 comments
pinaldave wrote 3 weeks ago: As PASS is now one week away and I am all excited for the same. I am going to attend following two s … more →
SQL SERVER - Difference Between Candidate Keys and Primary Key
— 15 comments
pinaldave wrote 3 weeks ago: Introduction Not long ago, I had an interesting and extended debate with one of my friends regarding … more →
