October, 2012

Posts
  • SQLPFE.IL

    Stop using TOP to page for data from now on use the OFFSET

    • 0 Comments
      With all the innovation that SQL 2012 bring to us in the T-SQL area we have the offset command. What is the offset command? I early version of SQL (before 2012) when we wanted to select out of a table a number of row we all have used the TOP command...
  • SQLPFE.IL

    SQL Server 2012 Audit Enhancements

    • 0 Comments
    SQL Server Auditing is useful for auditing the usage of your database operations. We've got quite a bit of new features and enhancements in SQL Server 2012. First, server level auditing is now available in all SQL Server 2012 editions. Database level...
Page 1 of 1 (2 items)