SAP ASE 16 new features

learning_sybase
learning_sybase used Ask the Experts™
on
Hi, could you please provide me the new features of sybase SAP ASE 16 version for DBA's and Developers.
I have searched lot on net but mostly find some generic features.
I need whats new for developers ?

Thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Principal Consultant
Most Valuable Expert 2012
Commented:
The "What's New" manual is updated for every release of ASE, including each new SP and PL release. It's freely available without registration at:

https://help.sap.com/viewer/791c41982ee345a19c4ec4b774222c4f/16.0.3.6/en-US

At a high level, features relevant to developers are:

- relaxed hard coded limits in queries
- star join query plan hints
- general query performance (especially for parallel queries and compressed data)
- full text auditing for tables and views
- "create or replace" so objects can be recreated with the same object ID, permissions, & auditing settings
- compression of indexes
- full database encryption
- create multiple triggers on a table, and specify the order in which they fire
- ability to calculate log growth rate
- reduced locking for partition operations
- dynamic histograms (update stats) for columns that are already increasing
- lockless data cache which is a game-changer for spinlock contention
- "Always On" or HADR; also game-changing but needs premium license (but is included in Platform Edition)
- tables as variables, user-defined functions, or procedure parameters
- control whether procedures are executed with caller's or owner's permissions
- select ... with limit/offset to skip and limit rows in result set
- alternatives to UNION: INTERSECT and EXCEPT
- global/persistent temporary tables
- temporary precomputed reusable result sets
- drop index with nowait
- enable/disable deferred compiltion per procedure

Also some things are removed:
- Developer Edition
- 32-bit Backup Server
- OpenSSL (replaced by Common Crypto Library)
- earlier versions of JRE (now only 7.1.055/7.1.060 and 8.1.037/8.1.046)

Many of these features depend on exactly which Service Pack and Patch Level you have. You need ASE 16.0 SP03 PL06 to have every feature I've listed.

Author

Commented:
awesome...many thanks

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial