Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Another new feature in SQL 2012- support for paging resu
Message
From
08/10/2013 23:32:44
 
 
To
08/10/2013 17:06:01
Metin Emre
Ozcom Bilgisayar Ltd.
Istanbul, Turkey
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
SQL Server:
SQL Server 2008
Application:
Web
Miscellaneous
Thread ID:
01585001
Message ID:
01585089
Views:
49
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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform