Stored procedures to implement paging for large tables or queries in SQL Server 2005 and SQL Server 2008
A tip from MSSQLTips that shows a few ways for implementing paging on large tables.
2009-03-12
5,878 reads
Additional Articles
How to Get Management Buy-In for Software purchases
There is a good chance that the process of purchasing software or hardware in your organization involves several people. DBAs will often initiate a request, but are not normally trained in the arts of influencing the management decision process to ensure that essentials get purchased. It is becoming essential to understand how to get Management support for software purchases. Dan offers nuggets of wisdom.
2009-03-11
2,005 reads
Process Dimensions in an Analysis Service database
Continuing our series on our "Microsoft Windows PowerShell and SQL Server 2008 AMO," Part 8 covers how to process a dimension in an Analysis Service database using Windows PowerShell and SQL Server 2008 AMO.
2009-03-11
2,147 reads
Installing SQL Server 2008 on a Windows Server 2008 Cluster Part 2
Windows Server 2008 has a lot of differences from its previous versions and one of them is the clustering feature. How do I go about building a clustered SQL Server 2008 running on Windows Server 2008?
2009-03-10
2,991 reads
Reasons Why You May Not Want to Use a Heap
For a book project I am working on, I have started compiling a list of reasons why heaps aren't usually a good choice when designing a database. Now, I didn't say that heaps are always bad, but in most cases, I think they should be avoided so pleae read the list to see why.
2009-03-10
3,333 reads
T-SQL Debugger is back in SQL Server 2008
Debugging capability in SSMS was a long sought feature by users and finally the Microsoft SQL Server team decided to provide this feature in SQL Server 2008.
2009-03-09
4,514 reads
Using schema binding to improve SQL Server UDF performance
SCHEMA BINDING is commonly used with SQL Server objects like views and User Defined Functions (UDF). The main benefit of SCHEMA BINDING is to avoid any accidental drop or change of an object that is referenced by other objects. A User Defined Function (UDF) may or may not access any underlying database objects, but in this tip we show how using SCHEMA BINDING with a UDF can improve performance even if there are no underlying objects.
2009-03-09
4,200 reads
Fast Guide: SQL Server Reporting Services
Check out this collection of best practices, troubleshooting advice and perfomance tips for working with SSRS in SQL Server 2005.
2009-03-06
6,137 reads
Integrating Visio 2007 with SQL Server Analysis Services
This article shows how Microsoft Office Visio 2007 can be used to visualize cube data created using SSAS
2009-03-06
2,488 reads
Introduction to SQL Server 2008 Report Builder 2.0
I have heard that there is a new version of Report Builder in SQL Server 2008. Can you provide some details and examples?
2009-03-05
4,254 reads
Blogs
Resetting on the AI hype train
By Brian Kelley
There's a great article from MIT Technology Review about resetting on the hype of...
A New Word: Etherness
By Steve Jones
etherness – n. the wistful feeling of looking around a gathering of loved ones,...
Vibe Coding a Login Tracking System
By Steve Jones
A customer was asking about tracking logins and logouts in Redgate Monitor. We don’t...
Forums
The Microsoft SQL Year in Review
Comments posted to this topic are about the item The Microsoft SQL Year in...
T-SQL in SQL Server 2025: The || Operator
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Your Value from a Conference
Comments posted to this topic are about the item Your Value from a Conference
Question of the Day
UNISTR Basics
What does this code return in SQL Server 2025+? (assume the database has an appropriate collation)
SELECT UNISTR('Hello 4E16754C') AS 'A Classic';
A: 
B: 
See possible answers