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

SQL SERVER – 2005 – Two Important Security Update

July 11, 2008

If you are using SQL Server 2005, following two are very important security updates not to be missed. Security Update for SQL Server 2005 Service Pack 2 (KB948108) A security issue has been identified in the SQL Server 2005 Service Pack 2 that could allow an attacker to compromise your…

SQL SERVER – 2008 – Introduction to SPARSE Columns

July 10, 2008

Pinal Dave

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

SPARSE Columns, SQL Data Storage, SQL Scripts

I have been writing recently about how SQL Server 2008 is better in terms of Data Stage and Backup Management. I have received very good replies from many users and have requested to write more about it. Today we will look into another interesting concept of SPARSE column. The reason…

SQL SERVER – 2008 – Two Convenient Features Inline Assignment – Inline Operations

July 9, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL Utility

Sometimes things just go very convenient and we wish that how come it was not available in earlier versions. Let us see two features here. If it was SQL Server earlier versions we might have to write more lines to achieve what we can achieve in lesser lines. Following small…

SQLAuthority News – Thank You to Awarding Author SQL MVP

July 7, 2008

Pinal Dave

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

Database, DBA, MVP

I received award from Microsoft for SQL Server Most Valuable Professional a week ago. I have received many many congratulations messages from many readers for getting this award. I thank all of you for sending me messages and your wishes. Honestly, I think this is all of yours award and…

SQL SERVER – 2008 – Introduction to Row Compression

July 6, 2008

Pinal Dave

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 – 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.…