ÈçºÎ¼ì²éSQL Server ÄÚ´æÆ¿¾±
DBCC memorystatus
--²éѯ»º³åÇø³ØÏûºÄµÄÄÚ´æ×ÜÁ¿°üÀ¨AWE
SELECT
SUM(multi_pages_kb+virtual_memory_committed_kb+shared_memory_committed_kb+
awe_allocated_kb) AS [Used by BPool, kb]
from sys.dm_os_memory_clerks WHERE type='MEMORYCLERK_SQLBUFFERPOOL'
--È·ÈÏÄÇЩÄÚ²¿×齨ÇÔÈ¡ÁË»º³åÇø³ØÖеĴ󲿷ֵÄÒ³Ãæ
SELECT TOP 10 type, SUM(single_pages_kb) AS stolen_mem_kb
from sys.dm_os_memory_clerks
GROUP BY type ORDER BY SUM(single_pages_kb) DESC
--È·ÈÏÔÚ»º³åÇø³ØÍâ·ÖÅäÁËÄÚ´æµÄÄÚ²¿×齨
SELECT type, SUM(multi_pages_kb) AS memory_allocated_kb
from sys.dm_os_memory_clerks
WHERE multi_pages_kb!=0
GROUP BY type
Ïà¹ØÎĵµ£º
The aspnet_Profile table contains the following fields: UserId, PropertyNames, PropertyValuesString, PropertyValuesBinary, and LastUpdatedDate. The PropertyNames field contains a string delimited with colons (:) that identify which profile fields are stored, what their datatype is and their of ......
BACKUP DATABASENAME WITH NO_LOGÒ»Ö±ÊÇÎҽضÏÊÂÎñÈÕÖ¾£¬Ñ¹Ëõ¿Õ¼äµÄÀûÆ÷£¬½ñÌìÔÙSQL2008ÉÏÒ»Óã¬È´²»ÁéÁË
ÏûÏ¢ 3032£¬¼¶±ð 16£¬×´Ì¬ 2£¬µÚ 2 ÐÐ
´ËÓï¾ä²»Ö§³ÖÒ»¸ö»ò¶à¸öÑ¡Ïî(no_log)¡£Çë²éÔÄÎĵµÒÔÁ˽âËùÖ§³ÖµÄÑ¡Ïî¡£
²é¿´Áª»ú°ïÖúÊֲᣬÀïÃæÈ·ÊµÃ»ÓÐwith no_logµÄ¿ÉÑ¡ÏîÁË£¬ÄÇÔõô°ì°¡£¬50MµÄÊý¾ÝÎļþ£¬2GµÄÈÕÖ¾Îļþ£¬È ......
SQL_Plus²Ù×÷ÃüÁî ¸½Â¼B SQL*PLUS
SQL*PLUS ÊÇOracleÌṩµÄÒ»¸ö¹¤¾ß³ÌÐò£¬Ëü²»½ö¿ÉÒÔÓÃÓÚ²âÊÔ£¬ÔËÐÐSQLÓï¾äºÍPL/SQL¿é£¬¶øÇÒ»¹¿ÉÒÔÓÃÓÚ¹ÜÀíOracleÊý¾Ý¿â
1.Æô¶¯sql*plus
ΪÁËʹÓÃsql*plus£¬±ØÐëÊ×ÏÈÒªÆô¶¯sql*plus¡£Oracle²»½öÌṩÁËÃüÁîÐкÍͼÐνçÃæµÄsql*plus£¬¶øÇÒ»¹¿ÉÒÔÔÚwebä¯ÀÀÆ÷ÖÐÔËÐÐ.
  ......
SQLÓï¾äʵÏÖ£¬SQL Server 2000 ¼°ACCESS¸´ÖƾɱíOldTableµÄ½á¹¹£¬»ò½á¹¹¼°ÄÚÈݵ½ÐµıíNewTable
Á½¸ö¶¼ÊÔ¹ýÁË£¬ÏÂÃæµÄ´úÂëÔÚÕâÁ½¸öÊý¾Ý¿âÖУ¨SQL Server 2000 ¼°ACCESS£©¶¼ÊÇ¿ÉÒÔͨ¹ýµÄ¡£
--¸´ÖƱí½á¹¹ÎªÐµıí
select * into NewTable
from OldTable where 1=2
--¸´ÖƱí½á¹¹¼°ÄÚÈݵ½Ðµıí
select * into newtable
......
Ê×ÏÈ´´½¨²âÊÔ±í¡¢Ìí¼ÓÊý¾Ý¡£
create table #t(a int,b int,c int,d int,e int)
insert into #t values(1,2,3,4,5)
insert into #t values(1,2,3,4,6)
insert into #t values(1,2,3,4,7)
insert into #t values(1,2,3 ......