MSSQL 2005 and row_count()
-
I am currently working in a MSSQL 2000 version and all of the paginated results for various scripts are done using 3 or more SELECT sub-queries. Unlike MySQL which only requires a single query --- I cannot see this being very efficient, especially the larger your database grows? I have done some googling and it turns out that row_count() is MSSQL answer since 2005 -- can anyone confirm whether this is the case and better yet refer me to some resources which I can read over the weekend to freshen up on MSSQL? Cheers, Alex
-
I am currently working in a MSSQL 2000 version and all of the paginated results for various scripts are done using 3 or more SELECT sub-queries. Unlike MySQL which only requires a single query --- I cannot see this being very efficient, especially the larger your database grows? I have done some googling and it turns out that row_count() is MSSQL answer since 2005 -- can anyone confirm whether this is the case and better yet refer me to some resources which I can read over the weekend to freshen up on MSSQL? Cheers, Alex
-
Do you happen to know of any benchmarks that compare the old style to the new?