Archiving SQL Server Data

Quite often , in a write - intensive system , data will turn historical and needs to be archived . There are performance gains , such as less records to scan , and reindexing. The sql statements related to deciding which data to archive is application specific. I'm outlining in this post , some cheap and effective ways of saving and storing large amounts of data.I will keep adding to this list

1)Use a tool such as SQLLiteSpeed which can compress 40 GB down to 2 GB.

2)Alternatively you can split the 40 GB into small chunks of a CD size using
some free tool like HJSPLIT

SQL Pagination

Pagination is a regular technique used for developing web applications. There are numerous methods of implementing pagination . Below, I'm creating  a list of methods that will allow both a SQL Server developer  and  web developer.

Method 1

/**Replace X & y with relevant numbers

**/

SELECT * FROM (
	SELECT TOP x * FROM (
		SELECT TOP y fields
		FROM table
		WHERE conditions
		ORDER BY table.field  ASC) as foo
	ORDER by field DESC) as bar
ORDER by field ASC