SQL ServerÖ®×é¼þ»®·Ö
´Ó²»Í¬µÄ½Ç¶È£¬ÎÒÃÇ¿ÉÒÔ°ÑSQL ServerÊý¾Ýƽ̨»®·ÖΪ¶à¸ö×é¼þ¡£ÎÒÃÇÏÂÃæ°´ÕÕSQL Server Internal Teamͨ³£µÄ»®·ÖÔÔò£¬°ÑSQL ServerÊý¾Ýƽ̨»®·ÖΪÈçÏ£º
SSAS: SQL Server Analysis Service¡£Ö÷ÒªÓÃÀ´×ö·ÖÎöÓ㬱ÈÈçCube£¬¿ÉÒÔ´Ó²»Í¬µÄ½Ç¶ÈÉóÊÓÊý¾Ý¡£
SSIS: SQL Server Integration Service¡£±ÈÈçExcelÊý¾ÝºÍÊý¾Ý¿âÊý¾ÝµÄ»¥²Ù×÷¡£
SSRS: SQL Server Reporting Service¡£Ö÷ÒªÓÃÀ´×öBI,×ö±¨±í¡£
Engine: SQL Server Engine¡£Êý¾Ý¿âµÄÒýÇ棬·Ç³£ÖØÒª£¬ºÃ±ÈÈ˵ÄÐÄÔàÒ»Ñù¡£
MPU: SQL ServerÊý¾Ý¿âµÄÍâΧ£¬±ÈÈçInstall,Uninstall,Upgrade,RepairµÈµÈ¡£
ÉÏÊö5´ó×é¼þ¹¹³ÉÁËÕû¸öSQL ServerÊý¾Ýƽ̨¡£ÓÉÓÚSQL Server Engine ÌرðÖØÒª£¬ÎÒÃÇÓÖ¿ÉÒÔ°ÑËü»®·ÖΪÈçϵÄComponents:
AM: Access Method¡£±È½Ïµ×²ã£¬Ö÷ÒªÓÃÀ´´æ´¢Êý¾Ý¡£
TS: Transaction Service¡£ÊÂÎñ£¬Ò»ÇÐÊÂÎñÊý¾Ý¿âµÄ»ù´¡¡£
FS: Filestream¡£SQL Server 2008µÄÐÂÔö¹¦ÄÜ£¬Ö÷ÒªÓÃÀ´´æ´¢>2GµÄÊý¾Ýµ½NTFS Driver¡£
QE: Query Execution¡£Ö÷Òª¸ºÔðSQL Óï¾äµÄÖ´ÐС£
QP: Query Process¡£Ö÷ÒªÓÃÀ´´¦ÀíÓû§IssueµÄSQLÓï¾ä£¬±ÈÈçT-SQLÓï¾äµÄÓÅ»¯£¬Ö´Ðмƻ®¡£
SQLOS: SQL Operation System¡£SQL Server 2008µÄÐÂÔö×é¼þ£¬ÎªÁË¿ØÖÆÊý¾Ý¿â¸ü¼ÓÁé»î£¬ÎªÖ®¿ª·¢ÁËÒ»¸öµ¥¶ÀµÄOS²ã¡£
Programmability£ºÖ÷ÒªÓÃÀ´¸ºÔðºÍVSµÈ±à³Ìƽ̨µÄÏνÓÒÔ¼°SQL±à³Ì£¬±ÈÈçAssembly£¬Óα꣬´æ´¢¹ý³Ì£¬´¥·¢Æ÷µÈµÈ¡£
XML£ºÓÃÀ´²Ù×÷XMLÊý¾Ý¡£
Replication£ºÓÃÀ´½øÐÐÊý¾ÝµÄ¸´ÖÆ£¬¸´ÖÆÊÇÊý¾Ý¿âµÄÒ»¸ö±È½ÏÓÐÓõŦÄÜ¡£
FullText£ºÓÃÀ´×öÈ«ÎÄË÷Òý¡£
SSB: SQL Server Service Broker£ºÒ»¸öµ×²ãµÄ×é¼þ£¬·Ç³£ÓÐÓã¬ÓÃÀ´±£³ÖͨѶµÄÒ»ÖÂÐÔ¡£
¶ÔÓÚÒÔÉÏEngineµÄ11¸öComponentsÖУ¬AM,TS,FS¹¹³ÉÁËSQL Server Storage Engine¡£ÖÁÓÚÿ¸ö×é¼þµÄ¹¦ÄÜ£¬ÎÒ»áÔÚÒÔºóµÄBlogÖнøÐÐÏêϸµÄÃèÊö£¬ÕâƪÎÄÕÂÖ÷ÒªÊÇÒ»¸ö´ó¸Å¡£
ÕâÀïÓм¸±¾Êé¿ÉÒÔ¹©´ó¼Ò²Î¿¼£º
Inside SQL Server 2000
Inside-MsSql2K5-SE (Inside Microsoft SQL Server 2005 Storage Engine)
Inside-MsSql2K5-P (Inside Microsoft SQL Server 2005 Programming)
Inside-MsSql2K5-TSql (Inside Microsoft SQL Server 2005 T-SQL Querying)
Inside-MsSql2K5-QTO (Inside Microsoft SQL Server 2005 Query Tuning and Optimization)
Ïà¹ØÎĵµ£º
----start
·²ÊÇÖªµÀÊý¾Ý¿âµÄÈ˶¼ÖªµÀSQL£¬·²ÊǶÔSQLÓÐÒ»µãÁ˽âµÄÈ˶¼¾õµÃSQLºÜ¼òµ¥£¬·²ÊÇÓÐÕâÖָоõµÄÈ˶¼ÊÇSQLµÃ³õ¼¶Óû§£¬ÒòΪËûѧ»áÁËÔö²éɾ¸Ä¾ÍÒÔΪÕâ¾ÍÊÇSQLµÄÈ«²¿¡£Ä¿Ç°µÄ´ó²¿·ÖÓ¦ÓÃÈí¼þ¶¼ÊÇÒÔÊý¾Ý¿âΪÖÐÐÄ£¬Ëæ×ÅÈí¼þµÄÔËÐУ¬Êý¾ÝÁ¿»áÔ½À´Ô½´ó¡£ÈçºÎÓüò½à¡¢¸ßЧµÄSQLÓï¾ä²Ù×÷Êý¾ÝÏÔµÃÔ½À ......
±¾ÏµÁÐÎÄÕµ¼º½
[Oracle]¸ßЧµÄPL/SQL³ÌÐòÉè¼Æ(Ò»)--αÁÐROWNUMʹÓü¼ÇÉ
[Oracle]¸ßЧµÄPL/SQL³ÌÐòÉè¼Æ(¶þ)--±êÁ¿×Ó²éѯ
[Oracle]¸ßЧµÄPL/SQL³ÌÐòÉè¼Æ(Èý)--PackageµÄÓŵã
[Oracle]¸ßЧµÄPL/SQL³ÌÐòÉè¼Æ(ËÄ)--ÅúÁ¿´¦Àí
[Oracle]¸ßЧµÄPL/SQL³ÌÐòÉè¼Æ(Îå)--µ÷Óô洢¹ý³Ì·µ»Ø½á¹û¼¯
[Oracle]¸ßЧµÄPL/SQL³ÌÐòÉè¼Æ(Áù)- ......
12 Essential Steps After Installing SQL Server
By : Sadequl Hussain
Jul 13, 2009
from: http://www.sql-server-performance.com/articles/dba/post_installation_steps_p1.aspx
Rolling out SQL Servers is a key task for
DBAs. While for some DBAs this can be a frequent exercise, others wi ......
CREATE PROC [dbo].[UP_EC_JOB_UpdateAddressType]
(
@Count INT
)
AS
BEGIN
SET NOCOUNT ON
DECLARE @TransactionNumber INT
DECLARE @Cursor CURSOR
SET @C ......
¡¡¡¡
¡¡¡¡¡ô¾¡Á¿²»ÒªÔÚwhereÖаüº¬×Ó²éѯ;
¡¡¡¡¹ØÓÚʱ¼äµÄ²éѯ£¬¾¡Á¿²»ÒªÐ´³É£ºwhere to_char(dif_date,'yyyy-mm-dd')=to_char('2007-07-01','yyyy-mm-dd');
¡¡¡¡¡ôÔÚ¹ýÂËÌõ¼þÖУ¬¿ÉÒÔ¹ýÂ˵ô×î´óÊýÁ¿¼Ç¼µÄÌõ¼þ±ØÐë·ÅÔÚwhere×Ó¾äµÄĩβ;
¡¡¡¡from×Ó¾äÖÐдÔÚ×îºóµÄ±í(»ù´¡±í£¬driving table)½«±»×îÏÈ´¦Àí£¬ÔÚfrom×Ó¾äÖа ......