>I create an empty cursor, append empty records equal related table at sql server. when user move page or jump anywhere at grid, fill empty records use with a code part from a thread from you and another developer from Europe (I'm not sure but maybe he was Walter Mester or another, sorry). That code part worked for me very well, thanks both of you.
>Maybe this feature works faster but needs SQL 2012 is not a good idea. Customers at Turkey usually don't upgrade their's SQL SERVER's. You know, SQL SERVER is not a visual application and if it works, enough for them...
>
>My memory is hazy, but I vaguely recall that Walter Meester and I shared some messages and code for paging back in 2007-2008.
>
>I understand the challenges of upgrading databases. It requires time and available people to go through the process. In the case of SQL 2012, they didn't add as much to the T-SQL language as they did in prior releases - one of the single biggest enhancements in the SQL 2012 is the columnstore index. The columnstore index can optimize some queries by a factor of 8-10 or more - that's huge, though it's only practical in data warehouse/data mart situations, not for OLTP databases.

IMO, a gigantic percentage of apps should be using some sort of ORM that abstracts away the details of the database.

NHibernate, for examples, has options to specify which SQL Server version to use, and will generate the SQL based on the version. Super cool.