As Gail siad, No Order By, no guarantee of order. End of Story.

As Perry says it could be an issue with exchange server. However did you check your junk folder?

http://blogs.msdn.com/b/psssql/archive/2009/09/11/fun-with-locked-pages-awe-task-manager-and-the-working-set.aspx

Found an article which is very interesting!!!

Hi Muthu,

I found the the lock pages in memory...

Probably this could because of LIN_NBR sorting. Whats the datatype of the columns. Please provide the table structure.

However to me it looks like the exepected behaviour that you are doing...

The Windows policy Lock Pages in Memory option is disabled by default. This privilege must be enabled to configure Address Windowing Extensions (AWE). This policy determines which accounts can use...

Please follow also the Gurus's series by Ken Henderson.

I personally do not like to use a function for the predicate. My call would be, create two temp table and load the data start with A to one table...

Please refer the below link too:

http://sqlzealot.blogspot.com/search/label/SQL%20server%20-%20Statistics

Thanks, It worked out well!!!

How can we validate the space saved using SPARSE on a table?

I made some columns as SPARSE columns. However am not able to see any difference...

When you create a new table, you have to add the table as an article.

This is not a problem at all. As Paul mentioned "This is a performance optimization that allows delete operations to complete more quickly."

ash0550 (6/8/2011)

---

I was trying to understand the count function but its not happening to the mark.

I am a bit unsatisfied with the explanations provided in different tutorials.

Could some one...

your are the best teacher to you!!! Learn yourself, you will never ever forget.

I do not think it is possible the session id generated by ASP.NET can be fetched from sQL server until you store the sessionid in a table and query.