What's the best process (performance wise) to paginate results in different versions of SQL Server (2000, 2005, 2008 and 2012) if you also want to find the total number of results (before pagination)? Thanks!
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!