Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Paging Problem SQL 2005 using row_number and order by Expand / Collapse
Author
Message
Posted Wednesday, May 13, 2009 6:05 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Tuesday, April 3, 2012 8:35 AM
Points: 1,608, Visits: 198
Views are treated no different than adhoc queries by SQL, unless you are doing Indexed Views. So the Execution plan for both adhoc and view will be the same.

Raymond Laubert
Exceptional DBA of 2009 Finalist
MCT, MCDBA, MCITP:SQL 2005 Admin,
MCSE, OCP:10g
Post #716584
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse