July 11, 2007 - SQL Authority with Pinal Dave

SQLAuthority News – SQL Blog SQLAuthority.com Comment by Mr. Ben Forta

July 11, 2007

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

Today is one of the most glorious day for SQLAuthority.com in history. Famous author of Sams Teach Yourself Microsoft SQL Server T-SQL In 10 Minutes, ColdFusion Guru, and well known evangelists Mr. Ben Forta has made comment on his blog about SQLAuthority.com. I encourage all my readers to visit comment…

SQL SERVER – 2005 – Features Comparison Chart

July 11, 2007

Pinal Dave

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

SQL Download

This post in the response to all the readers who have asked what are the differences between SQL Server 2005 editions. The reason I have never posted article about this as Microsoft has wonderful comparison chart on Microsoft SQL Server web site. This chart explains the difference between features of…

SQL SERVER – 2008 – Scheduled Launch at an Event in Los Angeles on Feb. 27, 2008

July 11, 2007

Pinal Dave

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

Database, SQL Scripts

SQL SERVER 2008 will be launched at an Event in Los Angeles on Feb. 27, 2008. “In anticipation for the most significant Microsoft enterprise event in the next year, Turner announced that Windows Server® 2008, Visual Studio® 2008 and Microsoft SQL Server™ 2008 will launch together at an event in…

SQL SERVER – Count Duplicate Records – Rows

July 11, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Duplicate Records, SQL Scripts

In my previous article SQL SERVER – Delete Duplicate Records – Rows, we have seen how we can delete all the duplicate records in one simple query. In this article we will see how to find count of all the duplicate records in the table. Following query demonstrates usage of…