alter database ... compression , lob_compression, inrow_lob_length
alter database ... log off ... = size from ... to ...
alter login profile
alter ... modify owner
alter table ... compressed
alter table ... add lob
alter thread pool
create database ... compression, lob_compression, inrow_lob_length
create login profile
create table ... compression, lob_compression
create thread pool
drop login profile
dump database ... with shrink_log
select ... into ... compression, lob_compression
- Unsupported platforms:
Open Server and SDK do not support HP-UX PA-RISC and Mac OS.
- In Adaptive Server 15.7, the maximum offset of a variable-length column for a data-only-locked (DOL) row has been expanded to 32767 bytes, which allows an Adaptive Server configured with a logical-page size greater than 8K to support wide, variable-length, DOL rows.
- Bulk-Library and bcp handling of nonmaterialized columns
Bulk-Library is enhanced to handle nonmaterialized columns in Adaptive Server 15.7. With this enhancement, you can only use Bulk-Library and bcp version 15.7 and later to bulk-copy-in data into Adaptive Server tables that are altered and contain nonmaterialized columns. Adaptive Server will raise an error when earlier versions of bcp are used to bulk-copy-in data into nonmaterialized columns.
ASE 15.7 key features include:
Management of Large Datasets
Ease of Application Development
The features fit into a few broad categories:
1. Dealing with large data sets. This includes better management of large objects, as well as enhancements to operational, storage, and data management tasks. With the costs of today’s high-end SANs, data compression may pay for the whole project.
2. Performance and scalability. New features here include better management of dynamic queries (I know that one is going to make friends) as well as a variety of ways to compress data, and better kernel integration for parallel processing performance.
3. More ease of maintenance. ASE 15.7 supports fully recoverable DDL commands such as select into, alter table, and reorg rebuild. In addition, you can now shrink log space, diagnostic support has taken a major step forward, and alter table statements can now be performed without copying data (how about that for speed of internal application upgrades?).
4. Application and developer productivity, including a variety of transact-sql enhancements.
5. Security, including object ownership changing, login profiles, and single sign-on
email any comments and suggestions to: email@example.com
And please, click on "+1" Google button !!
Important unknown new features in ISQL, for example :
- command line history,
- pipe, redirect output,
- error status,
1-10 of 13