Join the Ahmedabad SQL Server User Group Meeting August 2008 edition on August 30. I present CTE and Recursive CTE, and Jacob Sebastian covers isolation levels.
SQLAuthority News – 4 Million Visits – over 675 SQL Server Articles
Thank you to every reader: this blog has reached 4 Million Visits and over 675 SQL Server articles, and I was awarded SQL MVP along the way.
SQL SERVER – XML – Split a Delimited String – Generate a Delimited String
Two XML articles by my friend Jacob Sebastian show how to split a Delimited String and build one with FOR XML PATH, which can do more than COALESCE.
SQLAuthority News – Authors Personal Website Renovate – SQL Centric Website
My personal website pinaldave.com is renovated. It now links to my blog, shows excerpts of the latest SQLAuthority posts and has a new SQL tips section.
SQLAuthority Author Visit – Ahmedabad SQL Server User Group Meeting – July 19 2008
Notes from the July 19, 2008 Ahmedabad SQL Server User Group meeting, where I presented SQL Server Best Practices and enjoyed a lively discussion.
SQLAuthority News – Thank You to Awarding Author SQL MVP
Thank you for all the wishes on my SQL MVP award. It belongs to every reader here. Send me your ideas and I will publish them with your name on this blog.
SQL SERVER – Deprecated DataType vardecimal
vardecimal, added in SQL Server 2005 SP2, saves space for zero and null values. It is deprecated in SQL Server 2008, where Row Compression covers more datatypes.