Unbounded resultset warnings with new sql server paging syntax

[DanPlaskon]

I'm running some raw SQL queries via nhibernate and NHProf gives "unbounded resultset" warnings when using the new paging syntax introduced in SQL Server 2012+

For example:

select *

from foo

order by foo.name

offset 0 /* @p0 */ rows fetch next 250 /* @p1 */ rows only

Generates an "unbounded resultset" warning, even though we are limiting it to 250 records.

[Fitzchak Yitzchaki]

Hello,

Thanks for reporting this.

http://issues.hibernatingrhinos.com/issue/UberProf-199

Best Regards,

Fitzchak Yitzchaki

Hibernating Rhinos Core Team

Tel: +972-4-6227811

Fax: +972-153-4-6227811

--
You received this message because you are subscribed to the Google Groups "nhprof" group.
To unsubscribe from this group and stop receiving emails from it, send an email to nhprof+un...@googlegroups.com.
To post to this group, send email to nhp...@googlegroups.com.
Visit this group at http://groups.google.com/group/nhprof.
For more options, visit https://groups.google.com/d/optout.

[DanPlaskon]

Is there any update on this? 

I know it was slated for Version 3 of the profilers (perhaps coming soon?) - but with NHibernate 4 just being released, hql/linq queries now using this paging syntax by default. This is causing quite a few incorrect warnings to be raised by the profiler now.

[Oren Eini (Ayende Rahien)]

We hope to have a beta for 3.0 in the next 3 - 6 weeks.

It will contain support for this as well.

For the 2.x release, the workaround is to use the 2008 syntax for now.

Oren Eini

CEO

Mobile: + 972-52-548-6969

Office:  + 972-4-622-7811

Fax:      + 972-153-4622-7811

[DanPlaskon]

Fair enough - please hit me up if/when you need Beta testers!