Pinal Dave - SQL Server Performance Tuning Expert

SQL SERVER – Tuning the Performance of Change Data Capture in SQL Server 2008

October 28, 2009

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

Change data capture (CDC) is a new feature in SQL Server 2008 designed to capture insert, update, merge, and delete activities applied to SQL Server tables and to avail those changes in an easy-to-understand format. Conventionally, detecting changes in a source database to transfer these changes to a data warehouse…

SQL SERVER – How to Enable Index – How to Disable Index – Incorrect syntax near ‘ENABLE’

October 27, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Index, SQL Scripts

Many times I have seen that the index is disabled when there is large update operation on the table. Bulk insert of very large file updates in any table using SSIS is usually preceded by disabling the index and followed by enabling the index. I have seen many developers running…

SQL SERVER – Advanced T-SQL with Itzik Ben-Gan – A Dream Coming True

October 26, 2009

Pinal Dave

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

SQLAuthority Author Visit

As from my blog posts, all of you are probably aware that I am very much excited for attending SQL PASS at Seattle from Nov 1, 2009. As the days to the summit were nearing, I could already feel the rush of adrenalin in my veins. May be because of…

SQLAuthority News – Best Practices for Integration Services Configurations

October 25, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Business Intelligence, SQL White Papers, SSIS

Best Practices for Integration Services Configurations by Jamie Thomson This article explains what SQL Server Integration Services configurations are used for, why you should use Integration Services configurations, and what options you have for leveraging configurations. It will also make some simple recommendations that are based on my experiences of…

SQL SERVER – Link to SQL Server Book Online – BOL

October 24, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Do you keep following Book Online Links handy? I do and I use them a lot. SQL Server 2008 R2 SQL Server 2008 SQL Server 2005 SQL Server 2000 I do and I use them a lot. Reference: Pinal Dave (https://blog.sqlauthority.com)

SQLAuthority News – PASS Sessions – I will be there!

October 23, 2009

Pinal Dave

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

Business Intelligence, MVP, SQL PASS, SQLAuthority Author Visit

As PASS is now one week away and I am all excited for the same. I am going to attend following two sessions for sure. I encourage all of you to also visit the same sessions. We can all talk about SQL , SQL Integration as well Beyond Relations. First…

SQL SERVER – Difference Between Candidate Keys and Primary Key In Simple Words

October 22, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Constraint and Keys, SQL Scripts

Introduction Not long ago, I had an interesting and extended debate with one of my friends regarding which column should be primary key in a table. The debate instigated an in-depth discussion about candidate keys and primary keys. My present article revolves around the two types of keys. Let us…