I will speak on SQL Server Best Practices at the Ahmedabad SQL Server Usergroup meeting on July 19, 2008. Come meet fellow developers and DBAs.
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.
SQLAuthority News – Microsoft Most Valuable Professional Award for SQL Server – MVP
I am very glad to share that Microsoft has given me the Most Valuable Professional Award for SQL Server. Thank you to MVP Lead Abhishek and all my readers.
SQL SERVER – 2005 – Find Nth Highest Record from Database Table – Using Ranking Function ROW_NUMBER
Nicholas Paldino shared a neat way to find the Nth Highest Record from a table in SQL Server 2005 using the ranking function ROW_NUMBER. Here is his query.