MSSql Work Book UserPreferences
 
Help Info Print View Search Diffs Edit
 À妽º   Ã£±â   Freeboard   Subjectless   Images   ÃÖ±Ù±Û 

Version as of 2004-09-13 14:57:20

Clear message


¿ÀÈÄ 12:00 2004-09-13, p.280
where - any/some, all Å°¿öµå
a > any ( select 1 union select 5 union select 30 )
a > all ( select 1 union select 5 union select 30 )

anyÀÇ °æ¿ì 1, allÀÇ °æ¿ì 30º¸´Ù Ä¿¾ß ÇÔ.
(any Å°¿öµå´Â In°ú Ư¼ºÀÌ ºñ½Á)

order by ~ with rollup : ¿ä¾à Áý°è.
with cubeÀÇ °æ¿ì¿¡´Â A -> B ¹æÇâÀ¸·ÎÀÇ ¿ä¾àÁý°è »Ó¸¸ÀÌ ¾Æ´Ï¶ó B -> A ¹æÇâÀ¸·ÎÀÇ ¿ä¾àÁý°èµµ Áö¿øÇÑ´Ù.

¿ÀÈÄ 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)
money - -2^63 / 10^(-4) ~ (2^63-1) / 10^(-4), 8byte. (¼Ò¼öÁ¡ÀÌ µé¾î°£´Ù!)

Ä÷³ÀÇ Á¤ÀÇ ; Default, Identity, (Not) Null, Check, Rule, Trigger, Index
ruleÀº ÀÌÀü ȣȯ¼ºÀ» À§ÇÑ °´Ã¼

¿ÀÀü 11:16 2004-09-08
replication : publish - subscribe °Ô½Ã - ±¸µ¶
OLAP online analytical processing
OLTP online transaction processing
metadata service - manipulates system catalog
dts data transformation service
dtc distributed transaction coordinator

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ÀÇ ¿É¼ÇÀÌ »õ µ¥ÀÌÅͺ£À̽ºÀÇ ¼³Á¤¿¡ Àû¿ëµÊ.


ÇÁ·Î±×·¡¹ÖºÐ·ù


PythonPowered EditText of this page (last modified 2004-09-13 14:57:20)
FindPage by browsing, searching, or an index
Or try one of these actions: DeletePage, DeleteUploadedFile, LikePages, SpellCheck, UploadFile