Paging with SQL Server has always been a pain. Although SQL Server 2005 introduced some features that made it possible to page results efficiently more easily than ever before. Paging in SQL Server 2005 at 15 Seconds shows you how to do it with the new ROW_NUMBER() function.…
Read more »Great resources for MSSQL DBAs. Taken from InfoQ: Mark Souza of Microsoft has announced a new web site for database administrators and developers called SQL Server - Best Practices. This site offers a wide range of material from top 10 lists suitable for novices to the in-depth technical white papers needed by seasoned professionals. Topics include capacity planning, database mirroring, and bulk data loading. Over a dozen scripts for troubleshooting and performance tuning are also available.…
Read more »