News‎ > ‎

New Features in ASE 15.7 from QuickStart Guide

posted 28 Sep 2011, 07:14 by Fabien Reygrobellet   [ updated 28 Sep 2011, 11:05 ]
Global variables

@@kernelmode
@@lastkpgendate
@@lwpid
@@nextkpgendate
@@optlevel
@@ospid
@@plwpid
@@remotestate

Functions

cache_usage
create_locator
current_bigdatetime
current_bigtime
dol_downgrade_check
is_singleusermode
locator_literal
locator_valid
lprofile_id
lprofile_name
return_lob
setdata
show_cached_plan_in_xml
show_dynamic_params_in_xml
xact_connmigrate_check
xact_owner_instance

xmlextract
xmlparse
xmlrepresentation
xmltest
xmlvalidate

Commands

alter database ... compression , lob_compression, inrow_lob_length
alter database ... log off ... = size from ... to ...

alter login
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
create login profile

create table ... compression, lob_compression

create thread pool

dbcc forget_xact

deallocate locator

drop login
drop login profile

dump database ... with shrink_log

merge

select ... into ... compression, lob_compression

set builtin_date_strings
set compression
set send_locator
set show_transformed_sql
set statement_cache

truncate lob

Procedures

-- sp_addlogin

sp_merge_dup_inline_default
sp_monitor_server
sp_opt_querystats
sp_securityprofile
sp_showoptstats

System Tables

syscacheinfo
syscachepoolinfo
syspoolinfo
monDeviceSpaceUsage
monIOController
monLockTimeout
monRepLogActivity
monRepScanners
monRepScannersTotalTime
monRepSenders
monSQLRepActivity
monSQLRepMisses
monTableCompression
monTask
monThread
monThreadPool
monWorkQueue

Ċ
Fabien Reygrobellet,
28 Sep 2011, 07:21