Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Another new feature in SQL 2012- support for paging resu
Message
De
08/10/2013 23:32:44
 
 
À
08/10/2013 17:06:01
Metin Emre
Ozcom Bilgisayar Ltd.
Istanbul, Turquie
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Versions des environnements
SQL Server:
SQL Server 2008
Application:
Web
Divers
Thread ID:
01585001
Message ID:
01585089
Vues:
46
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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform