Because, going to a previous page, you would take the low bookmark and search backwards:

(Assuming 22 is the low bookmark)

SELECT TOP 10 IDField, OtherField

FROM Table

WHERE IDField...

quote:

---

...

SELECT TOP 10 * FROM <table> (INDEX (sortingIndex))

WHERE <criteria>

...

---

Wonderful suggestion, guarddata! ...

quote:

---

...for Example if the records perpage is 10, then for example there are 100 records in the table, so i will get...

quote:

---

I still don't see why you wouldn't use a composite index. As long as the first column is referenced in the...

Not the greatest article in the world. Very inefficient algorithm. Any time you see NOT IN used in a WHERE clause, there is cause for concern. A...

It is possible to have more than a single table's data in an extent, so the index fragmentation of other indexes housed in the same extents as this index may...

One more point on the fragmentation issue:

Simply issuing a DBCC DBREINDEX on the table will not affect logical and extent scan fragmentation numbers unless you are reindexing the clustered index....

BTW, tikus, this table does have clustered index on it, right? If not, the logical and extent scan frag numbers on SHOWCONTIG should be ignored. Just checking the...

I Agree with Calvin; be sure that the order of the columns in the composite key is that same of that in your queries.

--

But, back to the fragmentation question, tikus,...

I'll tell you right now that there's no use having an index on the ones that are 65% and 92.5% NULL saturation. To make an index worthwhile, there must...

What is the percentage of values in the table that are null for that column? It may not be advantageous to have an index at all...

Or, if you are in SQL2K QA, just press Ctrl-Shift-C to Comment Out, or Ctrl-Shift-R to Un Comment.

Well, what does happen? Can you post an example of what the procedure's results are, given certain parameters?

try:

DECLARE @Date SMALLDATETIME

SET @Date = '8/25/2003'

--

SELECT 

  @Date AS "Date"

, oh.CalDescr AS "Hour"

, ISNULL(oc.Calnote, '') AS "Note"

FROM #OutlookCalendar oc

  RIGHT JOIN #OutlookHours oh

 ...