|
| MSSql Work Book | UserPreferences |
master tempdb msdb model
page 8kb - header 96 bytes
extent 64kb - table, index's default unit.
mixed extent -> 8 pages over : regular extent
mdf master data file
ndf
ldf log data file
GAM global allocation map - process 4gb (64000 extents) 1 is unallocated, 0 is allocated.
SGAM shared global allocation map - process 4gb (64000 extents) 1 is mixed, and could be allocated, 0 is not mixed extent, or allocated.
table type data stream - protocol ; sql2000 - 8.0, sql7.0 - 7.0, sql6.5, 6.0, 4.21 - 4.2
transaction log
awe address windowing extensions - advanced server 8gb, datacenter serve 64gb ; 확장 메모리는 각 인스턴스에 정적으로 할당됨
data definition language
data manipulate language
data control language
sql-dmf distributed manage framework
automation : server agent, jobs, event and warning, trigger, manager?
import/export : dts, replication, bulkcopy(bcp), distributed query
dbcc database
sp_helpdb
sp_dboption
sp_configure
model database의 옵션이 새 데이터베이스의 설정에 적용됨.
컬럼의 정의 ; Default, Identity, (Not) Null, Check, Rule, Trigger, Index 오후 2:02 2004-09-09, p.210
decimal - 유효 38자리. numeric과 동일
float - -1.79e +308 ~ 1.79e +308, float(53)의 경우 double precision과 동일
real - float(24)와 동일, -3.40e+38 3.40e+38
float(n)
n = 1~24, 정밀도 7자리, 4byte
money - -2^63 / 10^(-4) ~ (2^63-1) / 10^(-4), 8byte. (소수점이 들어간다!)
n = 25~53, 정밀도 15자리, 8byte
rule은 이전 호환성을 위한 객체
프로그래밍분류
EditText
of this page
(last modified 2004-09-09 14:56:54)