Pinal Dave - SQL Server Performance Tuning Expert

SQL SERVER – 2008 – Introduction to Row Compression

July 6, 2008

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

SQL Backup and Restore, SQL Data Storage, SQL Scripts

In my previous article SQL SERVER – 2008 – Introduction to New Feature of Backup Compression I wrote about Row Compression and I have received many request to write in detail about Row Compression. I like when I get request about any subject to write about from my readers. Row…

SQL SERVER – Difference Between Database Mail and SQLMail

July 5, 2008

Pinal Dave

SQL

Database Mail, Service Broker, SQL Scripts, SQL Server Security

In recent user group meeting in my city Ahmedabad, I have found that not every user knows difference between these two features of SQL Server. I do not blame any user for not knowing difference between Database Mail and SQLMail as this is very confusing sometime. I will try to explain this concept here.

SQL SERVER – Deprecated DataType vardecimal

July 4, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

MVP

I received following email yesterday from Satnam Singh- Computer Programmer from Bangalore. “Dear Pinal, Congratulations for being MVP. You truely deserved it. I wonder why have you never written newly introduced feature of vardecimal. Keep up good work! Satnam Singh Developer – Bangalore.” In SQL Server 2005 SP2 they have…

SQL SERVER – 2008 – Introduction to New Feature of Backup Compression

July 3, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Backup and Restore, SQL Data Storage, SQL Scripts

Backup and Data Storage is my most favorite subject and I have not written about this for some time. I was experimenting with new feature of SQL Server 2008 and I come across very interesting feature of Backup compression. Let us see example of Database AdventureWorks with and without compression.…

SQL SERVER – 2008 – Insert Multiple Records Using One Insert Statement – Use of Row Constructor

July 2, 2008

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

SQL Scripts

I previously wrote article about SQL SERVER – Insert Multiple Records Using One Insert Statement – Use of UNION ALL. I am glad that in SQL Server 2008 we have new feature which will make our life much more easier. We will be able to insert multiple rows in SQL…

SQLAuthority News – Microsoft Most Valuable Professional Award for SQL Server – MVP

July 1, 2008

Pinal Dave

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

Database, DBA, MVP

I am very glad to announce that Microsoft has awarded me Most Valuable Professional Award for SQL Server. I would like to thank Microsoft and MVP Lead Abhishek for awarding this honor to me. MVP is most prestigious award and I am very pleased to receive it. I thank all…

SQL SERVER – 2008 – High Availability – Hot Add Memory

June 30, 2008

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

After reading my previous article about SQL SERVER – 2008 – High Availability – Hot Add CPU the same developer who suggested Hot Add CPU asked me if there are any restrictions in Hot Adding Memory. Yes, there are few restictions to Hot Add Memory as well. I am listing…