SQL Server Archives - Page 263 of 393 - SQL Authority with Pinal Dave

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

October 27, 2009

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…

SQLAuthority News – PASS 2009 Sessions on Query Optimization and Performance Tuning

October 20, 2009

Pinal Dave

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

Best Practices, Database, MVP, SQL PASS, SQLAuthority Author Visit

PASS Summit 2009 is now only 10 days away and I am very excited for the same. I can not wait to attend the summit as this is the most awaited conference of SQL Server in world. Everybody will be there and there will be something for everybody. My core…