aaaaaaaahhhh pagination.... nice example!! Ask to your DBA if he sent an issue to MsSQL team asking for a human-oriented-syntax for pagination stuff. I mean something similar to ORACLE, Firebird, MySQL, Postgre etc. etc. or even something like SqlCe4... We can accept even something like this: SELECT SKIP 100 TAKE 25 ........... FROM ...... WHERE ..... ORDER BY ......
On Thu, Sep 2, 2010 at 1:59 PM, Joseph Daigle <[email protected]>wrote: > Hi Frans, > > > care to share the name of this community member? :) > > Send me an e-mail and I'll share it offline (I don't want to burn > anyone unnecessarily). > > > care to share one as an example? I.o.w. I think it's more of an > edge > > case when you run into these limitations, with any o/r mapper btw. Often > > these queries are using temp tables, cursors etc. > > They are edge cases. And as I said, we can drop down to stored > procedures when necessary to resolve these edge cases. > > > what does 'not stable' mean, exactly? Correlated subqueries are > > either correct, or not, but 'unstable' is IMHO a term not used in > > combination of correlated subqueries. > > "not stable" is a term the consultant used, which I believe means that > the sql statement performance will not scale linearly as the load > increases and/or table size increases > > > An example would be great. > > The example used: > > SELECT ... > FROM ... > WHERE [Id] IN ( > SELECT TOP 200 > [Id] > FROM ... > WHERE ... > ORDER BY ... > ) > WHERE ... > > versus > > SELECT ... > FROM ( > SELECT ..., > ROW_COUNT() OVER(ORDER BY...) AS [row_num] > FROM ... > WHERE ... > ) > WHERE ... > AND [row_num] < 200 > > The former is what we can generate with NHibernate using Criteria. The > second we cannot. > > Thanks, > > -- > Joseph Daigle > > -- > You received this message because you are subscribed to the Google Groups > "nhusers" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]<nhusers%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/nhusers?hl=en. > > -- Fabio Maulo -- You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/nhusers?hl=en.
