Da Notes - 70-028 - C

Personal notes on the MCDBA tests. These notes are from the various resources I used to pass the MCDBA exams including the MCDBA sample exams from Transcender.

Passing Score: 680, Questions: 52,  Time: 90 Minutes

Da Notes Index 

[ 70-028 - B ] [ 70-028 - C ] [ 70-028 - D ] [ 70-028 - F ] [ 70-028 - H ] [ 70-028 - I ] [ 70-028 - L ] [ 70-028 - M ] [ 70-028 - N ] [ 70-028 - P ] [ 70-028 - R ] [ 70-028 - S ] [ 70-028 - U ] [ 70-028 - W ]

Character Set, Sort Order, Unicode Collation

Character Set, Sort Order, Unicode Collation (1252)
· Default Character Set: Code Page 1252 - Most used and compatible with UNIX and VMS 
· Default Sort Order: Dictionary, case insensitive 
· Default Unicode Collation: General Unicode, case insensitive, width insensitive, Kana insensitive 

· Code page 850 - multi lingual character set that includes all the characters used by most languages of European, North and South America
· Code page 437 - Common US character set but use 1252 unless really have a good reason
· Sp_helpsort will display the current sort order

Care must be taken when configuring the character set, sort order, or Unicode collation. Changing any of these requires rebuilding the master database and reloading data. 

Changing Sort Order, Character Set, Unicode Collation after Installation 
1. Backup object definitions you wish to preserve by using Enterprise Manager to create scripts. 
2. Export data using DTS or BCP 
3. Rebuild master database using rebuildm utility, specifying new sort order, character set, or Unicode collation. (You will need the installation CD) 
4. Create databases using EM or CREATE DATABASE statement 
5. Create objects using scripts generated in step 1. 
6. Import data using BCP or DTS. 

Clustering Service

1. Run SQL Clustering Service setup on a new SQL Server 7.0 installation using the Failover Setup Wizard 

2. Identify the disk names controlled by the primary node of the cluster on which you will install SQL Server. 

3. Stop any additional services such as IIS, MTS, MSDTC, and Exchange that may be running or installed by default on the cluster, right-click the resource; then click Take Offline. 

4. Run Setup.exe from the SQL Server 7.0 directory of software compatible with your processor architecture. 

5. Specify a shared drive controlled by the primary node of the cluster where you want SQL Server to be installed, in the SQL Server Installation Path dialog box, and in the Master Database Installation Path dialog box. 

6. Named Pipes is required only for installing SQL Server and SQL Server Cluster Setup. If you want to use another network protocol for normal business operations, ensure that it is also selected. 

7. Start SQL Server, check the installation, and then stop SQL Server. The installation program will install the necessary SQL Server management tools to the local drive. In the event of a failover, you will be able to manage the SQL Server virtual server through normal graphical user interface (GUI) operations. 

8. On the Start menu, point to Programs/Microsoft SQL Server 7.0/Failover, and then click Failover Cluster Wizard. 

9. Select options (Virtual server, 'sa' Password, IP address, virtual server name) 

10. Confirm your choices, or click Backup to make the necessary corrections. 

Create Database

It is recommended that you specify a maximum size to which the file is permitted to grow. This prevents the file from growing, as data is added, until disk space is exhausted.

CREATE DATABASE Sales ON
( NAME = Sales_dat, FILENAME = 'c:\mssql7\data\mydb_data.mdf',
SIZE = 10, MAXSIZE = 50, FILEGROWTH = 5 )
LOG ON
( NAME = 'Sales_log', FILENAME = 'c:\mssql7\data\mydb_log.ldf', SIZE = 5MB,
MAXSIZE = 25MB, FILEGROWTH = 5MB )