Divine Data

The goal is to turn data into information, and information into insight.

Wednesday, 8 January 2014

New Paging Techniques in Oracle 12c & Sql Server 2012

The following articles contains new best approaches for pagination in oracle and sql server.

http://www.oracle-base.com/articles/12c/row-limiting-clause-for-top-n-queries-12cr1.php#top-n

http://www.codeproject.com/Articles/442503/New-features-for-database-developers-in-SQL-Server
Posted by Raju at 22:24
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Books and Videos

  • ssis-tutorials
  • ssrs-tutorials
  • Building a Data Warehouse
  • SQL Server Integration Services (SSIS) Articles
  • SQL Server Execution Plans By Grant Fritchey

My Blog List

About Me

Raju
View my complete profile

Blog Archive

  • ▼  2014 (10)
    • ►  June (9)
    • ▼  January (1)
      • New Paging Techniques in Oracle 12c & Sql Server 2012
  • ►  2013 (40)
    • ►  November (26)
    • ►  August (2)
    • ►  July (5)
    • ►  June (6)
    • ►  April (1)

MS BI, SQL SERVER

  • Loop through Flat Files in SQL Server Integration Services
  • SSMS Part 1 - Part 10 (Beyond Relational)
  • SSIS Part 1 - Part 11 (Beyond Relational)
  • SSRS Part 1 - Part 10 (Beyond Relational)
  • SSAS Part 1 - Part 10 (Beyond Relational)
  • Queries/Procedures/Views in SSRS DataSet
  • SQL SERVER – Stored Procedure – Clean Cache and Clean Buffer
Awesome Inc. theme. Powered by Blogger.