Bài 1: Giới thiệu SQL Server 2000 ppsx

lktlucky2002@yahoo.com Page 1 of 44

Bài 1: Gi
i Thiu SQL Server 2000


  

     

   

  

!"!

 #!!$! %!!

&  #'%
( ( ) *


 +, !" +- 

 ! .

 "/ 



"/0%  #'%
$!"1!!$!2!!$!34*5+,





3$ /673!" #'%
0


 +898+,:,;&<=8>

?

@A&!

#!!$!B"(

<+CD!E'&:,/**5

F"0

 

: , 7C 9/ GH G @ 3  73 8 %""I J JI"!"
 JJ
(2 BE."

2K"L&
0000


:M"N

•   N.4!+O&+P3+Q8P!

:,;&<

<+C

R.KSTUV' W%0D<"+:::3X*F/"/Y Z

?

W!

&
(

• N ?Z9/"3=&[!\]3^_"@B/

B"28

;$X@; 4H!"?/!!I!(732"&:

,;&<

<+CU.KSV' W%0

•  N+898:!+,;&<K.<:,+Q<OC3/<$`"`

7,a"`bc0

•    N.:+O&+P3ZHP!B/B"8+89C;"+Q$8@

;

898>7C"
5 

F0000dY&

"3$;e


 O :0 .F ! f 5 " & "  7:! e0 B" & : ,  <

a"` K"I"!

!&agDa"7!"0

•     %
#B(NdY& h

   ;& < 7"/  7= :  I!

!"(0DZ9/",7!4*3&

0iZ8@!!$!$X@;

7"V'0

• N#5"34*;&<a"`.B

•
N.:3ZHP!B/B"2"`

"!I28@;>!)*0

1.1. Cài Ðt SQL Server 2000 (Installation)

.3$;O:   Z?

TU%' W%2j %'!7+,:,!




0 '; : , !

 < a"`
 !& a"` kK K"I"!

2 a"`  

K"I"!

!&gDa"7!"87=,!

<abcI!

&0

A] "+Q+,P!3/l%""I

m!

<F=7=]

$&C_3!

!&3$8@!

h]$&3+,O

87!

=0gC

3$;Q/;"!

]:,+8!

<I"+,\ <0i!

$;O

83

+,!N

n]4!$;e   0
!7!

L"

$;:

,!

<W!

&
C$;Z0

n] $;e   
0

!+:$;<e7, !"#3$ /6P!

0g"!<

 !$$%&'% I!

(

n]( ) @e)* ) 08]

:,5

 C +  $"6 &( @agD o : , 5 C +  $"6 < P! :0 D"

lktlucky2002@yahoo.com Page 2 of 44

K""
 8> ! 8> 5 a"` W!" ] +  ! " !"   m  "

8>

;"8>)*0gp!

 7$;+89?/6!!(7C

""!]$;:&_&6/

!!!("

0D&<!<e%L

%"+,m"e6/0

!7 !

 $; f ?&  " q : / $< 8@ ]2+Y&Z




%!!0';:,
!2
"/3

m$q3"$

E

7""&0

1.2. Mt chút kin thc v các Version ca SQL Server


P!%""I+89X8>?/6 r7,["T0j0
!+:%""I

+rCO8C

; @"

M0 0."<:,:["T0j

<

"M0 

 $8@&e0.: +QZP!

M0 7=8Z@"

T0j0D"7+:[A"M0 

<"c0 

 (]CP&C

 

3ZH_`$

"

 +36&0

% +,+Q$+3

8" 

)  0g:"m,

$;:

,!

" @3"8@7=O/!

F0gp!

$;:,

;&"""T0j"QM0 @" <5 3&+_&7=,L&!@

3"8@+Y&(0i+:"o<3&$;

  s" @[!

!

f

+  0

1.3. Các thành ph n quan tr

ng trong SQL Server 2000


 +89?;"$_/O8 

!"!

#!!$!B2W!

&

B

&0000.3/O&7/9/@!;" /3/"h

F/"

8/YZ

 3m0

lktlucky2002@yahoo.com Page 3 of 44

1.3.1. Relational Database EngineE.3

tP!

N

dY&

 :7H4!!!3&=73!8@;!$



//"?37,7C!!""(=*P!%""I8Wk#!!

u$vW#u(2uB#'2!u/#!!$!."&u#'.(0g"!:s:7Hw

+_h/(Z*8)*<3&<"(P!3&7O

;

&<"+_7 

""II0

1.3.2. ReplicationE.C;"$!" /

!(N

V)$;: !!$!5+,4!

+8934*8>L&<6/

60% &+x/>$;: 3!!$!&8C< 73

+,;&$3"3"/"!!$!(3

&8>5+,38+C

/I"!P!Z(0A?+_

/"P!$;oO/+896/6

8>L&<+,+$"ZZL3P!3$3"3"0';7=,5C$!7/

!""8>9/&0DC]$;/

!"yF+:C/

!"P!


f+89)*+,$"+"

!!$!+89+1$ &"z(0

/

!"f+89$7{"$|

1.3.3. Data Transformation Service (DTS,E% X*&,X!!=5



gC$;

" =&

@"+:!!+894!"_73

!3;73!*,84!"u!

2#'P!J'%(2

2

%""IW0000';}}f:O&,!!!3&!!&

!I(7=h&,$;s+X;I"!(:8@7

8"!!$!

7327+:$;f?&#D
F/$;&C=<m8C"0#D
f

+89$7{"$c0

1.3.4. Analysis Service -% X*/YZ

?!&P!%""I

#

#!!(4!"!!$!f~:p!]_C8$;7=,

?&+89=JI"!"($-Z[+:0#"+:%""I?/"$; =

*?;F/"/YZ

<m$q3573

]7__

E"$(7{6G+"\

G!!(f+89

F=@"$|R0

1.3.5. English Query -% X*8>Ag!}

Z5NE(y(

dY&

 X*F/"&!!$qCWGG/

!B

(0

1.3.6. Meta Data Service:

#X*&F/"4!+wGL"?G%!!!m0DC]%!

#!!

3]6&y%!!!

==_?FP!!!"!!$!8

!! 

";"
!&J0002  "+::/

K!&7&!&7=0000']

=&o+894!"!!$!<o

 ;!!8+,/Y

$@!!GZG8>!e:

%!#!!0KO&}

$;/L<

" /O73P!

}/@!+Y&



  -. ]

7=:$""

";$&:t_X*&0

1.3.7. SQL Server Books Online - &,iD37=,CN

lktlucky2002@yahoo.com Page 4 of 44

."5$;:+e3373!;&_
]$;of?&$""7

"

&?*7=,C+89"<%""I@"/:+Z7"


(0

1.3.8. SQL Server Tools -dY&

 $ +1_P!8>X

#'W(

ÄC7,C!]_+?&"<$;O+e<"$""7"

0

n+Y&8>Ch7,! =*=*=0

dO</7,+C  ) 0dY&

 =*"!?&"



 3?w!0g:?Z+Q$"8>@e7==

;"

}_
0

iC+C



 /(/0 0d@ #'W\]O8hO=*&

:,

 !!$!7=O+C4730dY&

 =8>



73]!:,+3$?7ÅY


";&!&

6/4+Q$

:F/"!

$?&3"/"m0

.=*4$!O/7,+C



 0g::7HG*/G!/(?3w

7!&";+ m!< 


8

;8@;LI

?*"

7,"3";+ P!

0

g" =*w!8<F!o8>!&51$

7

"/&(""!/"/0