Everything about database,how to,example,guide, - SQL Serverhttp://teachmesql.net/MSSQL Tutorial,MySql Tutorial,access Tutorial,Foxpro Tutorial,Oracle Tutorial,PowerBuilder,how to database,intro to database,intro to mysql,intro to sql,intro to foxpro, - RainbowSoft Studio Z-Blog 1.8 Arwen Build 81206zh-CNCopyright 2008 teachmesql.net. Some Rights Reserved.Tue, 07 Sep 2010 23:29:03 +0800Technology of SQL Server database (34)a@b.com (rain)http://teachmesql.net/post/222.htmlTue, 03 Mar 2009 09:37:52 +0800http://teachmesql.net/post/222.html6.5.1 deletes a database with Enterprise Manager
 Right key is clicked on the database that should delete in place in Enterprise Manager,Choose from inside quick menu " delete (Delete) " option can delete a database,Also can choose database folder or icon chooses to delete a database from inside tool column after icon.Meeting clew affirms the system to whether want to delete a database,Place of the 6-9 that be like a graph is shown.

Delete a database must discreet,According to library hind because of cutout divisor,Meet with file of database of this database related and clerical log file by cutout,Except memory all about this database information in systematic database also can be deleted.
Notice:Cannot be deleted when the database is in the following condition:The database is being used;The database is being restored;The database includes the boy or girl friend that is used at what duplicate to had been published.

6.5.2 deletes a database with command of DROP DATABASE
Command of DROP DATABASE can delete from inside SQL Server or a few databases.Database place
DBO of the person that have and database manager DBA just have authority to execute this order.Its grammar is as follows:
DROP DATABASE Database_name [, . . .n]
Exemple 6-13:Delete database Abc.Drop Database Abc

Moving result is as follows
Deleting Database File 'E:\Program Files\Microsoft SQL Server\MSSQL\data\abc_Log.LDF' .
Deleting Database File 'E:\Program Files\Microsoft SQL Server\MSSQL\data\abc_Data.MDF' .

...]]>SQL Serverhttp://teachmesql.net/post/222.html#commenthttp://teachmesql.net/http://teachmesql.net/feed.asp?cmt=222http://teachmesql.net/cmd.asp?act=tb&id=222&key=f017b3f0The introduction of perfectness database series - foundation piece 1a@b.com (rain)http://teachmesql.net/post/88.htmlTue, 03 Mar 2009 09:37:52 +0800http://teachmesql.net/post/88.html
? ? is a memory that can move actually, software system that safeguard and uses a system to provide data,The aggregate that is object of memory medium, processing and administrative system.It is comprised by software, database and data manager normally.Its software basically includes all sorts of operating system, host languages,Utility program and database management system.The database is the data gather in model of some kind of data organizes according to and depositing two class memory.These data serve for many application,Independent at specific applied process.The database consolidates management by database management system,The insertion of data, revise and retrieve all should manage a system to undertake through the database.Database management system is software of a kind of system,Its main function is data of share of the random in maintain a database and visitting a database effectively.To the database maintain the integrality that includes to carry data, consistency and security.Data manager is in charge of founding, monitoring and maintain whole database,Make data can be used effectively by any people that authority is used.Database manager is by professional skill the personnel with taller, deeper qualifications and record of service is held the position of commonly.

The individual meaning of system of ? ? database is to show a specific database manages systematic software and the database that build with it;Its course meaning is to point to research, development, build, the subject that place of the theory that safeguard and uses database system place to involve, method, technology makes.Below this one meaning,A database system is software research domain main branch,Often call database field.

? ? database considers to span to be mixed at software of computer application, system academic three domains,Apply the development that promotes new system to develop among them,New system brings new academic research,And before academic research is opposite again two domains are having direct effect.A milepost that the occurrence of database system is computer application,It makes succeed in one's scheme calculates machine application from give priority to with scientific computation change direction to be given priority to with data processing,Make the computer is able to use generally in all trades and professions and even family thereby.Although the file system before it also can process abiding data,But the quick visit that file system does not provide pair of aleatoric share data,And it is crucial for the application that this increases ceaselessly to data bulk.The quick visit that occupies to come true to be counted to aleatoric part,Be about to study a lot of optimizing technology.These optimize a technology often very complex,It is average user come true hard,So by systematic software (database management system) will finish,And those who provide an user is the database language that uses easily simply.Because be opposite,the operation of the database is finished by database management system,So the database can become independent to exist at specific applied process,Thereby the database can be shared for many users place again.Because of this,The independent character of data and the main feature that sharing a gender is database system.Data is shared saved material resources of much labor power,The wide application that is database system laid a foundation.The occurrence of database system makes average user can stock daily data the computer conveniently and visit them quickly when need,The computer that makes thereby walks out of scientific research orgnaization to enter all trades and professions, enter a family.

...]]>SQL Serverhttp://teachmesql.net/post/88.html#commenthttp://teachmesql.net/http://teachmesql.net/feed.asp?cmt=88http://teachmesql.net/cmd.asp?act=tb&id=88&key=973baa95Technology of SQL Server database (23)a@b.com (rain)http://teachmesql.net/post/212.htmlTue, 03 Mar 2009 09:37:52 +0800http://teachmesql.net/post/212.htmlThe method of the server that start has the following to plant:

1, start with Enterprise Manager
The server that clicks place to want to start with wrong key in the SQL Server Group of Enterprise Manager,Or after right key is clicked on the server that place should start,Choose from inside quick menu " Start " ,Can start.

2, start with SQL Server Service Manager
The method that start is as follows:
(1) chooses option of Service Manager from inside menu,The service that start manages implement.Service government implement after starting,Place of the 5-2 (a) that be like a graph is shown;
(The server that 2) chooses to want to start in Service Manager (Server) and service (Service) option;
(3) clicks pushbutton in Service Manager,Namely Start/Continue option,The server that start.The picture after starting is shown like graph 5-2 B.

...]]>SQL Serverhttp://teachmesql.net/post/212.html#commenthttp://teachmesql.net/http://teachmesql.net/feed.asp?cmt=212http://teachmesql.net/cmd.asp?act=tb&id=212&key=2cf86a00Technology of SQL Server database (24)a@b.com (rain)http://teachmesql.net/post/213.htmlTue, 03 Mar 2009 09:37:52 +0800http://teachmesql.net/post/213.htmlCan use in SQL Server register guide and register attribute dialog box two kinds of means will register a server.Register a process to be as follows:

(1) chooses to operate in the menu of Enterprise Manager (Action) menu,From individual event of dish of New SQL Server Registration of the choice in Action menu,Or the server of Register SQL Server Wizard (that chooses icon to if place of graph 5-4 is shown,can appear from inside tool column registers guide) dialog box.If chose in the first interface of guide dialog box answer choose casing (the place in the 5-4 that be like a graph is shown) hind,Press " next " pushbutton registers interface of attribute dialog box to the server with respect to meeting changeover,Place of the 5-5 that be like a graph is shown.Also can click Microsoft SQL Servers or SQL Server Group with right key,Choose individual event of dish of NewSQL Server Registration from inside quick menu.

...]]>SQL Serverhttp://teachmesql.net/post/213.html#commenthttp://teachmesql.net/http://teachmesql.net/feed.asp?cmt=213http://teachmesql.net/cmd.asp?act=tb&id=213&key=4eeabad2Technology of SQL Server database (25)a@b.com (rain)http://teachmesql.net/post/214.htmlTue, 03 Mar 2009 09:37:52 +0800http://teachmesql.net/post/214.htmlPlace is clicked to want connective server with wrong key in the SQL Server Group of Enterprise Manager,Or after right key is being clicked on the server that should start in place, choose from inside quick menu " Connect " ,Can start.If chose to input Zhang date and countersign option when SQL Server is started when registering a server (place of the 5-8 that be like a graph is shown) ,Can hint input they,Place of the 5-12 that be like a graph is shown.

...]]>SQL Serverhttp://teachmesql.net/post/214.html#commenthttp://teachmesql.net/http://teachmesql.net/feed.asp?cmt=214http://teachmesql.net/cmd.asp?act=tb&id=214&key=3557484fTechnology of SQL Server database (26)a@b.com (rain)http://teachmesql.net/post/215.htmlTue, 03 Mar 2009 09:37:52 +0800http://teachmesql.net/post/215.htmlThe property that configures a server is very principal to administrative SQL Server.Can undertake configuration through two kinds of means.

1, with business management implement configuration
After right key is being clicked on the server that wanting to undertake configuration in Enterprise Manager, choose from inside quick menu " attribute (Properties) " option,The dialog box that if place of graph 5-13 is shown,can appear namely,The property that can have a server is installed.

...]]>SQL Serverhttp://teachmesql.net/post/215.html#commenthttp://teachmesql.net/http://teachmesql.net/feed.asp?cmt=215http://teachmesql.net/cmd.asp?act=tb&id=215&key=98df5375Technology of SQL Server database (27)a@b.com (rain)http://teachmesql.net/post/216.htmlTue, 03 Mar 2009 09:37:52 +0800http://teachmesql.net/post/216.htmlEnterprise Manager offerred visible interface,Amid establishs database and its target,Wait like value of watch, view, default,Him user of very few need editor code.But to the user,Knowing these boy or girl friends is how to pass SQL language to build,get script of language of its SQL (Script) is to have profit very much.the tool was provided in Enterprise Manager,The script of SQL language that produces these boy or girl friends in order to help an user.
The method of SQL script that makes a target is as follows:

(The target that 1) chooses to want to create SQL scenario in Enterprise Manager,Click right key,From inside quick menu " all tasks (All Tasks) " child dish of Generate SQL Scripts of the choice in menu is individual,The dialog box that if place of graph 5-15 is shown,can appear.

(2) creates the setting in the dialog box in SQL script after option,Click " Preview " pushbutton can play those who if place of graph 5-16 is shown,go out to preview a dialog box namely.Can click " Copy " pushbutton,Can duplicate script statement in clipboard.Also can choose in graph 5-15 " affirmatory " pushbutton,Appoint script file name and deposit the position.




The SQL script that arises by Enterprise Manager is suffixal name is " .sql " file,It is file of a text actually (Text File) ,Can be browsed in Enterprise Manager or other file editor or revise.The SQL script that can make all database target when necessary,The backup that occupies its the library as logarithm.When the database damages,Script of this SQL can move to rebuild in Query Analyzer database.

...]]>SQL Serverhttp://teachmesql.net/post/216.html#commenthttp://teachmesql.net/http://teachmesql.net/feed.asp?cmt=216http://teachmesql.net/cmd.asp?act=tb&id=216&key=6bb29188Technology of SQL Server database (28)a@b.com (rain)http://teachmesql.net/post/217.htmlTue, 03 Mar 2009 09:37:52 +0800http://teachmesql.net/post/217.htmlIn business management implement in can very call tool of other SQL Server conveniently,If SQL Server Query Analyzer (inquires analyzer) , tracker of SQL Server Profiler () wait,Simply from " Tools (tool) " the tool with the corresponding choice in menu can.
Many guide tool was provided in SQL Server 2000,Can guide an user to finish a series of database and server management job.Can from " Tools (tool) " choose in menu " Wizards " option,Or the Select Wizard (that chooses icon to if place of graph 5-17 is shown,can appear from inside tool column chooses guide) dialog box.The guide of SQL Server that chooses to want to call from which,Can appear the dialog box that is similar to a server to register guide,The operation is very handy.



Additional,SQL Server 2000 improved task board,Amid added guide board piece,Make of guide call more forthright, intuitionistic.The method that calls task board is fall in server of some of the choice in cultivating the window " Databases " a database in the group,Reelection choose " examine (View) " in menu " Taskpad (task board) " option.It is next in task board window choice " Wizards " page,The interface that if place of graph 5-18 is shown,can see.The guide that can choose to want to call from which.


...]]>SQL Serverhttp://teachmesql.net/post/217.html#commenthttp://teachmesql.net/http://teachmesql.net/feed.asp?cmt=217http://teachmesql.net/cmd.asp?act=tb&id=217&key=e24cb7a6Technology of SQL Server database (29)a@b.com (rain)http://teachmesql.net/post/218.htmlTue, 03 Mar 2009 09:37:52 +0800http://teachmesql.net/post/218.html
Manage a database
Manage database object
Manage backup
Management is duplicate
Management logins and permit
Manage SQL Server Agent
Manage SQL Server Mail

We will be in the following paragraphic in content of detailed introduction above.

This order is right business management implement made a few simple introductions.The open that told about a server, shut wait for knowledge.In the following paragraphic in can use business management implement,The usage that we will be familiar with it stage by stage and skill.

...]]>SQL Serverhttp://teachmesql.net/post/218.html#commenthttp://teachmesql.net/http://teachmesql.net/feed.asp?cmt=218http://teachmesql.net/cmd.asp?act=tb&id=218&key=f11e8659Technology of SQL Server database (30)a@b.com (rain)http://teachmesql.net/post/219.htmlTue, 03 Mar 2009 09:37:52 +0800http://teachmesql.net/post/219.html1, file and file group
In SQL Server the database is comprise by database file and clerical log file.A database should include file of a database and file of log of a thing at least.
(File of 1) database (Database File)
Database file is the file that deposits database data and database object.A database can have file of one or more database,File of a database belongs to a database only.When having many databases file,A file is defined to give priority to database file (Primary Database File) ,Patulous name is Mdf,The starting information that it uses memory database and part or full data,A database can have only advocate database file.Other database file is called database file (Secondary Database File) ,Patulous name is Ndf,Use memory main body of a court verdict the other data that did not store.

Use many databases file to store the advantage of data is reflected in:
database file need not break augment,And the restriction that does not accept volume of operating system file;
can be database filestore in different hard disk,Can do data to access to a few hard disk at the same time so,The efficiency that improved data processing.To the server model the computer particularly useful.

(File of log of 2) general affairs (Transaction Log File)
Clerical log file is with the file that will record a database to replace a situation,Patulous name is Ldf.Use INSERT, UPDATE, DELETE for example, wait to undertake to the database more operate metropolis record to be in this file,And won't influential according to library content like the logarithm such as SELECT operation criterion won't on record.A database can have file of log of one or more general affairs.

Use in SQL Server " Write-Ahead (write ahead of schedule) " the general affairs of means,Be opposite namely of the database revise in keeping clerical daily record first,Write a database again.Its provide gymnastics to make is,The system will change an operation to be written into clerical log first,Change memory again in the data in computer cache,To improve executive efficiency,This changes the database that won't be written in hard disk instantly,Carry out CHECKPOINT in order to secure the time-interval of 4 to command by the system however,Write has changed data lot hard disk.SQL Server has a characteristic,Setting of the meeting when it is carrying out data to change begins dot and an end drop,If have not arrive at knot spot to make operate because of some kind of reason,interrupt,The data that can restore automatically to already was revised when SQL Server is started afresh,Make its return the position that was not altered.This shows,When the database is destroyed,Can restore database content with clerical log.

(Group of 3) file (File Group)
File group is many databases file gather rises a formation whole.Every file group has name of a team.Like database file,File group also is divided give priority to file group (Primary File Group) with second file group (Secondary FileGroup) a file can consist in in group of a file,Group of a file also can be used by a database only.Advocate all systems were included to express in file group.When building a database,Advocate file group includes advocate database file and did not appoint the other file of the group.Team of file of a default can be appointed in second file group,So in if was not appointed,putting its in which file group when establishing database target,In can putting it in default file group.If did not appoint default file group criterion main body of a court verdict group,For default file group.
Notice:Clerical log file does not belong to any file groups.

6.1.2 founds a database with Enterprise Manager
Following measure can be pressed to found a database in Enterprise Manager:
(1) the icon in clicking tool column,Or right key is clicked on the Databases folder of the server or icon of its subordinate database,Choose New Database... option,The dialog box that if place of graph 6-1 is shown,can appear namely.
(2) the name that designates a database and encode means,Place of the 6-1 that be like a graph is shown.

Graph 6-1 founds database dialog box
(3) clicks casing of page of Transaction Log,Size of position of the name that designates database file, memory, initiative capacity and place belong to file group,Place of the 6-2 that be like a graph is shown.
(4) undertakes means of augment of database file size and capacity restrict a setting,Place of the 6-2 that be like a graph is shown.
(5) clicks casing of page of Transaction Log,Position of the name that designates clerical log file, memory and initiative capacity size,Place of the 6-3 that be like a graph is shown.
(6) undertakes means of augment of size of clerical log file and capacity restrict a setting,Place of the 6-3 that be like a graph is shown.

...]]>SQL Serverhttp://teachmesql.net/post/219.html#commenthttp://teachmesql.net/http://teachmesql.net/feed.asp?cmt=219http://teachmesql.net/cmd.asp?act=tb&id=219&key=6e636c9d