Optimising Server-Side Paging

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Paul White » Optimising Server-Side Paging - Part II

22 posts, Page 3 of 3

«««1 2 3

Optimising Server-Side Paging - Part II

Rate Topic

Display Mode

Topic Options

Author

Message

tim.sewell

Posted Tuesday, November 09, 2010 9:58 AM

Forum Newbie

Group: General Forum Members
Last Login: Today @ 2:55 PM
Points: 3, Visits: 148

ha I knew that was coming. This is a very rudimentry example, but it gives you an idea of the issue

--create table #test (clientID int,contactID int,firstname varchar(255),lastname varchar(255),linkID int)
--insert into #test VALUES (1,1,'tim','s',1)
--insert into #test VALUES (1,1,'tim','s',2)
--insert into #test VALUES (1,1,'tim','s',2)

--select * FROM #test
;WITH
keys AS
(
SELECT DISTINCT contactID,firstname,lastname,linkID
,(SELECt count(*) FROM #test) as allrecords
FROM #test

)
SELECT * FROM keys

is that enough to make more sense of what I was saying?

Cheers

Tim

Post #1018052

tim.sewell

Posted Thursday, November 18, 2010 2:52 AM

Forum Newbie

Group: General Forum Members
Last Login: Today @ 2:55 PM
Points: 3, Visits: 148

Anyone got any thoughts on this?

Post #1022711

« Prev Topic | Next Topic »

22 posts, Page 3 of 3

«««1 2 3

Permissions