WindowsÏÂÆô¶¯Í£Ö¹SQL Server 2005·þÎñ
ºÜ¶à¼¼Êõ°®ºÃÕߵĵçÄÔÉÏ×ÜÊÇ°²×°Á˺ܶàÈí¼þ£¬°üÀ¨Ó¦ÓÃÈí¼þ¡¢¿ª·¢¹¤¾ßÈí¼þ¼°Êý¾Ý¿âÈí¼þ£¬µ«ÊÇËæ×Åʱ¼äµÄÁ÷ÊÅ£¬ÂýÂýµØµçÄÔÉÏ×°µÄÈí¼þÒѾ³¬³öÁ˵çÄÔ±¾ÉíËùÄÜ
³ÐÔصÄÁ¿ÁË£¬Òò¶ø³öÏÖÁ˵çÄÔÔËÐÐËÙ¶ÈÂýµÈÎÊÌ⡣ͬʱ£¬Ò²ÓÐһЩµ¥Î»»ò¸öÈ˵ĵçÄÔÓÉÓÚ³ö³§Äê´úÓÐЩ¾ÃÔ¶£¬¼´Ê¹Ö»°²×°Ò»ÖÖ»ò¼«ÉÙÊýÈí¼þʱҲ»áÏÔʾ³öÔËÐÐËÙ¶ÈÂý
µÄÏÖÏó¡£Èç¹ûÎÒÃDz¢²»ÊÇ̫Ƶ·±Ê¹ÓÃijЩÈí¼þ£¬ÎªÁ˼ӿì»úÆ÷µÄÔËÐÐÏìÓ¦Ëٶȣ¬ÎÒÃǾͻáÑ¡ÔñÔÝÍ£ÕâЩÈí¼þÏà¹ØµÄ·þÎñÒÔ¼õÇáÄÚ´æ¡¢CPUµÄ¸ºÔØ¡£ÏÂÃæÎÒÃǽ«
SQL Server 2005×÷Ϊһ¸öÀý×ÓÀ´½éÉÜһϡ£
SQL
Server±¾ÉíÊÇÒ»¸öºÜÕ¼×ÊÔ´µÄÈí¼þ£¬¹âÒ»¸öʵÀý·þÎñËùÕ¼Äڴ棬¸ù¾ÝÆ䰲װʱ·ÖÅäµÄÄÚ´æ¾ÍÖÁÉÙÒª´ïµ½256MBÒÔÉÏ£¬ÔÙ¼ÓÉÏÆäËû¸½Êô·þÎñ£¬¹âÄÚ´æ¾ÍÒªÕ¼
ÓÃÎïÀíÄÚ´æµÄ20-30%×óÓÒ£¬ÖÁÓÚCPU£¬SQL ServerÒ²ÐèÒªÕ¼ÓÃ20%×óÓÒ£¬Òò¶ø£¬ÎÒÃÇ¿¼ÂÇÔÚÓÐÐèҪʹÓÃSQL
ServerʱÆôÓÃÆäÏà¹Ø·þÎñ£¬Æ½Ê±ÔòÍ£Ö¹¸Ã·þÎñ¡£
ÎÒÃÇÄÃSQL Server
2005×÷ΪÀý×Ó¡£Ê×ÏÈÔÚ“¿ªÊ¼=¡µÔËÐДÖÐÊäÈë“services.msc”£¬°´»Ø³µ£¬½øÈë“·þÎñ”¿ØÖÆ̨£¬½«SQL Server (MSSQLSERVER)¡¢SQL Server Agent
(MSSQLSERVER)¡¢SQL Server Analysis Services
(MSSQLSERVER)¡¢
SQL Server FullText
Search (MSSQLSERVER)¡¢SQL Server Integration Services¡¢SQL Server
Reporting Services (MSSQLSERVER)
¼°
SQL
Server VSS Writer
·þÎñµÄÊôÐÔÖÐÆô¶¯ÀàÐÍÐÞ¸ÄΪ“ÊÖ¶¯
”£¬È»ºóÔÚÐèҪʹÓÃʱÆô¶¯SQL Server (MSSQLSERVER)¡¢SQL Server Analysis
Services (MSSQLSERVER)¡¢SQL Server FullText Search (MSSQLSERVER)¡¢SQL
Server Integration Services¡¢SQL Server Reporting Services (MSSQLSERVER)
¼°SQL Server VSS Writer
ÕâЩ·þÎñ£¬²»Ê¹ÓÃʱͣ
Ö¹£¬¶øÇÒÕâÑù×ö¼´Ê¹»úÆ÷¹Ø»ú»òÖØÆôºó£¬Ä¬ÈÏϵͳ»¹ÊDz»»áÆô¶¯ÕâЩ·þÎñµÄ¡£µ±È»ÎÒÃǽ¨Ò齫Æô¶¯Í£Ö¹·þÎñµÄ²Ù×÷дÔÚÒ»¸öÅú´¦ÀíÎļþÖз½±ãʹÓá£
ÏÂÃæÎÒÃǸ½ÉÏÆô¶¯¼°Í£Ö¹SQL Server 2005·þÎñµÄÅú´¦ÀíÎļþÄÚÈÝ£¨¾ßÌåÅú´¦ÀíÎļþÇë¼û¸½¼þ£©£º
Æô¶¯SQL Server 2005·þÎñ£º
@echo off
@ ECHO Æô¶¯SQL Server 2005
·þÎñ
net start "SQL Server (MSSQLSERVER)"
net start "SQL Server
Analysis Servic
Ïà¹ØÎĵµ£º
--ÉèÖÃÊý¾Ý¿âÊä³ö£¬Ä¬ÈÏΪ¹Ø±Õ£¬Ã¿´Îдò¿ª´°¿Ú¶¼ÒªÖØÐÂÉèÖÃ
set serveroutput on
--µ÷Óà °ü º¯Êý ²ÎÊý
execute dbms_output.put_line('hello world');
--»òÕßÓÃcallµ÷Óã¬Ï൱ÓÚjavaÖеĵ÷ÊÔ³ÌÐò´ò×®
call d ......
This has some predictable results that we can use for building queries. The root is always of the form (left = 1, right = 2 * (SELECT COUNT(*) from TreeTable)); leaf nodes always have (left + 1 = right); the BETWEEN predicate defines the subtrees; and so on. Here are some common queries that you can ......
Ò»¡¢»ù´¡
1¡¢ËµÃ÷£º´´½¨Êý¾Ý¿â
CREATE DATABASE database-name
2¡¢ËµÃ÷£ºÉ¾³ýÊý¾Ý¿â
drop database dbname
3¡¢ËµÃ÷£º±¸·Ýsql server
--- ´´½¨ ±¸·ÝÊý¾ÝµÄ device
USE master
EXEC sp_addumpdevice 'disk', 'testBack', 'c:\mssql7backup\MyNwind_1.dat'
--- ¿ªÊ¼ ±¸·Ý
BACKUP DATABASE pubs TO testBack
4¡¢Ëµ ......
Ò»¡¢³õʼ°²×°ÇëÏÈ°²×°sqlserver 2000 ÔÙ°²×°sqlserver 2005
¶þ¡¢Èç¹ûÖÐ;sqlserver2000Óöµ½ÎÊÌâÐèÒªÖØ×°£¬Çë°´ÒÔϲ½Öè
1.ÔÚ¿ØÖÆÃæ°å->Ìí¼Óɾ³ý³ÌÐòÖÐɾ³ýsqlserver2000
2.ÔÚ¹ÜÀí¹¤¾ß->·þÎñÖÐÍ£Ö¹sqlserverµÄËùÓзþÎñ
3.ÊÖ¶¯É¾³ýC:\Program Files\Microsoft SQL ServerĿ¼ÏµÄ80Ŀ¼ºÍMSSQLĿ¼£¨±ØÐëÒªÓеڶþ² ......