SQL server 2005»ùÓÚÒÑ´æÔÚµÄ±í´´½¨·ÖÇø
< type="text/javascript">
< type="text/javascript">
Èç×ªÔØ£¬Çë×¢Ã÷³ö´¦£ºhttp://blog.csdn.net/robinson_0612/archive/2009/11/07/4783702.aspx
Ëæ×ŵ±½ñÊý¾Ý¿âµÄÈÝÁ¿Ô½À´Ô½¿ìµÄ³¯×ÅÔÚ´óÐÍÊý¾Ý¿â»ò³¬´óÐÍÊý¾Ý¿âµÄ·¢Õ¹£¬¶ÔÓÚÊý¾Ý¿âÖеĴóÐͱíÒÔ¼°¾ßÓи÷ÖÖ·ÃÎÊģʽµÄ±íµÄ¿ÉÉìËõÐԺͿɹÜÀíÐÔÔËÐл·¾³±äµÃ
ÓÈÎªÖØÒª£¬SQL server´ÓSQL server 7.0µÄ·ÖÇøÊÓͼµ½SQL server 2000ÖеķÖÇøÊÓͼÖе½SQL server
2005ËùʹÓõķÖÇø±í£¬²»¶Ï¸ÄÉÆ´óÐͱíËùÃæÁÙµÄÐÔÄÜ¡¢×èÈû¡¢±¸·Ý¿Õ¼ä¡¢Ê±¼ä¡¢ÔËÓª³É±¾µÈ¡£µ±±íºÍË÷Òý·Ç³£´óµÄʱºò£¬Í¨¹ý·ÖÇø±íµÄʵÏÖ£¬¿ÉÒÔ½«Êý¾Ý·ÖΪ¸ü
С£¬¸üÒ×ÓÚ¹ÜÀí£¬»ñµÃ¸üºÃµÄ¿É²Ù×÷ÐÔÄÜ¡£±¾ÊµÑé½éÉÜ»ùÓÚÒÑ´æÔڵıíÀ´ÈçºÎ´´½¨·ÖÇø£¬¹ÜÀí·ÖÇø¡£
Ò»¡¢ÊµÑéÄ¿µÄ£º¶ÔÓÚÒѾ´æÔڵıíÇÒ²»¶ÏÔö´óµÄÇé¿öϹ¹½¨·ÖÇø±í£¬¹ÜÀí·ÖÇø±í£¬Ìá¸ßÆäÐÔÄÜ¡£
¶þ¡¢Ö÷Òª²½Ö裺¶ÔÓÚÒѾ´æÔÚµÄ±í£¬ÎÒÃÇ¿ÉÒÔ²ÉÈ¡ÒÔϲ½ÖèÀ´¶ÔÆä´´½¨·ÖÇø±í
1.´´½¨·ÖÇøº¯Êý
2.´´½¨·ÖÇø¼Ü¹¹²¢¹ØÁªµ½·ÖÇøº¯Êý
3.ɾ³ýÒѾ´æÔڵľۼ¯Ë÷Òý
4.»ùÓÚ·ÖÇø¼Ü¹¹Öؽ¨¾Û¼¯Ë÷Òý
Èý¡¢ÊµÑé»·¾³£º
1. windows xp pro (Ó¢Îİæ) + sp2
2. SQL server 2005 Developer + sp3
3.ʵÑéÊý¾Ý¿âPerformance,´ËÊý¾Ý¿â²ÎÕÕʵÑé¶þ£ºSQL server 2005¸ß¿ÉÓÃÐÔÖ®----Êý¾Ý¿â¾µÏñ
ÖеÄÉú³É½Å±¾Éú³ÉÊý¾Ý¿â£¬±¾ÊµÑé¶ÔÆäÊý¾Ý¿âµÄ´æ·Å×öÁ˵÷Õû£¬½«Êý¾ÝºÍÈÕÖ¾Îļþ´æ·ÅÔÚD:\SQL_Data\PerformanceĿ¼Ï¡£
4.¶ÔÒÑ´æÔÚÒª´´½¨µÄ·ÖÇø±íΪ£ºPerformanceÊý¾Ý¿âϵÄOrders±í.
5.¶ÔOrders±íÖеÄorderdateÁа´Äê½øÐÐˮƽ·ÖÇø
ËÄ¡¢¾ßÌåÊÔÑé²½Ö裺
1.´´½¨·ÖÇøº¯Êý
È·¶¨·ÖÇøµÄÊýÄ¿¼°·ÖÇøµÄÁУ¬ÁеÄÊý¾ÝÀàÐÍ¡£±¾Àý½«Orders±íµÄorderdate°´Äê·Ýˮƽ·ÖÎå¸öÇø£¬ÔòÐèÒª¶¨ÒåËĸö±ß½çµãÖµ¡£ÈçÏ£¬
use Performance;
go
Create partition function
Part_func_orders(datetime) as
range left
for values('20021231 23:59:59.997',
'20031231 23:59:59.997',
&nb
Ïà¹ØÎĵµ£º
Ò»¡¢ÉèÖóõʼ»¯²ÎÊý job_queue_processes
¡¡¡¡sql> alter system set job_queue_processes=n;£¨n>0£©
¡¡¡¡job_queue_processes×î´óֵΪ1000
¡¡¡¡
¡¡¡¡²é¿´job queue ºǫ́½ø³Ì
¡¡¡¡sql>select name,description from v$bgprocess;
¡¡¡¡
¡¡¡¡¶þ£¬dbms_job package Ó÷¨½éÉÜ
¡¡¡¡°üº¬ÒÔÏÂ×Ó¹ý³Ì£º
¡¡¡¡
¡¡ ......
SELECT CONVERT(varchar(100), GETDATE(), 0): 05 16 2006 10:57AM
SELECT CONVERT(varchar(100), GETDATE(), 1): 05/16/06
SELECT CONVERT(varchar(100), GETDATE(), 2): 06.05.16
SELECT CONVERT(varchar(100), GETDATE(), 3): 16/05/06
SELECT CONVERT(varchar(100), GETDATE(), 4): 16.05.06
SELECT CONVERT(varch ......
MySQL
ÊÇÒ»¸öÕæÕýµÄ¶àÓû§¡¢¶àÏß³ÌSQLÊý¾Ý¿â·þÎñÆ÷¡£SQL£¨½á¹¹»¯²éѯÓïÑÔ£©ÊÇÊÀ½çÉÏ×îÁ÷Ðеĺͱê×¼»¯µÄÊý¾Ý¿âÓïÑÔ¡£MySQL
ÊÇÒÔÒ»¸ö¿Í»§»ú/·þÎñÆ÷½á¹¹µÄʵÏÖ£¬ËüÓÉÒ»¸ö·þÎñÆ÷ÊØ»¤³ÌÐòmysqld
ºÍºÜ¶à²»Í¬µÄ¿Í»§³ÌÐòºÍ¿â×é³É¡£
SQLÊÇÒ»ÖÖ±ê×¼»¯µÄÓïÑÔ£¬ËüʹµÃ´æ´¢¡¢¸üкʹæÈ¡ÐÅÏ¢¸üÈÝÒס£ÀýÈ磬ÄãÄÜÓÃSQLÓïÑÔΪһ¸öÍøÕ¾¼ìË ......
ÔÎĵØÖ·£ºhttp://topic.csdn.net/u/20100203/17
/8F916471-597D-481A-B170-83BCEFE3B199.html
============================ÎÒÊÇ·Ö¸î
·û================================
Ó¦Ò»¸öÅóÓѵÄÒªÇó£¬ÌùÉÏÊղصÄSQL³£Ó÷ÖÒ³µÄ°ì·¨¡«¡«
±íÖÐÖ÷¼ü±ØÐëΪ±êʶÁÐ
£¬[ID] int IDENTITY (1,1)
1.·ÖÒ³·½°¸Ò»£º(ÀûÓÃNot InºÍSELECT ......
create PROCEDURE sp_decrypt(@objectname varchar(50))
AS
begin
set nocount on
--CSDN£ºj9988 copyright:2004.07.15
--V3.2
--ÆÆ½â×Ö½Ú²»ÊÜÏÞÖÆ£¬ÊÊÓÃÓÚSQLSERVER2000´æ´¢¹ý³Ì£¬º¯Êý£¬ÊÓͼ£¬´¥·¢Æ÷
--ÐÞÕýÉÏÒ»°æ"ÊÓͼ´¥·¢Æ÷"²»ÄÜÕýÈ·½âÃÜ´íÎó
--·¢ÏÖÓÐ´í£¬ÇëE_MAIL£ºCSDNj9988@tom.com
begin tran
......