Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ÈçºÎ¼ì²é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


Ïà¹ØÎĵµ£º

SQL 2008 ÌåÑéµÚÒ»²¨

´Ó2000¿ªÊ¼¾ÍÊÇMS SQL¼ÒµÄÖÒʵÓû§ÁË£¬2000µÄʱºòÎÒÊÇ´ÓÒ»±¾2000±¦µä¿ªÊ¼ÈëÃŵ쬴Ó2000µ½2005¾­ÀúÁ˺ܳ¤Ê±¼ä£¬ºÜ¶àµÄÓû§ÖÁ½ñ»¹ËÀËÀµÄÊØ×Å2000£¬Èç¹û²»Êǹ¤³ÌÒªÇ󣬹À¼ÆÎÒÒ²²»»áÖ÷¶¯»»µ½2005£¬È»¶øÑÛ¾¦Ò»Õ££¬2008ÓÖ³öÀ´ÁË£¬°§Ì¾£¬2005µÄ¹¦ÄÜÎÒ¶¼Ã»ÓÐÃþÍ¸ÄØ¡£
2008Óë2005µÄ¶Ô±È
1.Âý£¬Ê²Ã´¶¼Âý£¬´Ó»Ö¸´Êý¾Ý¿â£¬µ½µ¼ÈëÊý¾Ý ......

SQL 2008 ½Ø¶ÏÊÂÎñÈÕÖ¾²»ÄÜÓÃÁË£¿£¿

BACKUP DATABASENAME WITH NO_LOGÒ»Ö±ÊÇÎҽضÏÊÂÎñÈÕÖ¾£¬Ñ¹Ëõ¿Õ¼äµÄÀûÆ÷£¬½ñÌìÔÙSQL2008ÉÏÒ»Óã¬È´²»ÁéÁË
ÏûÏ¢ 3032£¬¼¶±ð 16£¬×´Ì¬ 2£¬µÚ 2 ÐÐ
´ËÓï¾ä²»Ö§³ÖÒ»¸ö»ò¶à¸öÑ¡Ïî(no_log)¡£Çë²éÔÄÎĵµÒÔÁ˽âËùÖ§³ÖµÄÑ¡Ïî¡£
²é¿´Áª»ú°ïÖúÊֲᣬÀïÃæÈ·ÊµÃ»ÓÐwith no_logµÄ¿ÉÑ¡ÏîÁË£¬ÄÇÔõô°ì°¡£¬50MµÄÊý¾ÝÎļþ£¬2GµÄÈÕÖ¾Îļþ£¬È ......

sql 2000 ¸´ÖƱí

SQLÓï¾äʵÏÖ£¬SQL Server 2000 ¼°ACCESS¸´ÖƾɱíOldTableµÄ½á¹¹£¬»ò½á¹¹¼°ÄÚÈݵ½ÐµıíNewTable
Á½¸ö¶¼ÊÔ¹ýÁË£¬ÏÂÃæµÄ´úÂëÔÚÕâÁ½¸öÊý¾Ý¿âÖУ¨SQL Server 2000 ¼°ACCESS£©¶¼ÊÇ¿ÉÒÔͨ¹ýµÄ¡£
--¸´ÖƱí½á¹¹ÎªÐµıí
select * into NewTable
from OldTable where 1=2
--¸´ÖƱí½á¹¹¼°ÄÚÈݵ½Ðµıí
select * into newtable ......

How To Use Dynamic Sql in Sql Server ?

How To Use Dynamic Sql in Sql Server ?
 
¶¯Ì¬SQL ÔÚsql server ProcedureÖеÄÓ¦ÓÃ
 
 
Create PROCEDURE [dbo].[Proc_Get_Serial_No]
        (
         @Table_Name varchar(20),
      ......

ÕýÊÔ½øÈëlinq to sqlѧϰ

¶àÓàµÄ»°¾Í²»¶à˵ÁË£¬ÕýÊÔlinq to sqlµÄѧϰ¡£
ÏÈÀ´¿´¿´linq to sql µÄÌØÐÔ:
×Ô¶¯ÊôÐÔ(Auto-Implemented Properties)
Òþº¬ÀàÐ;ֲ¿±äÁ¿(Local Variable Type Inference)
ÄäÃûÀàÐÍ(Anonymous Types)
¶ÔÏóÓ뼯ºÏ³õʼ»¯Æ÷(Object and Collection Initializers)
À©Õ¹·½·¨(Extension Methods)
Lambda±í´ïʽºÍLambda±í´ïʽ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ