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

MSSQLÖмì²éËùʹÓõÄÓï¾äÊÇ·ñ±ê×¼

 ¼ì²éËùʹÓõÄÓï¾äÊÇ·ñ±ê×¼
 /*
     ±ê×¼SQLºÍT-SQLÖ®¼äÓкܶàÇø±ð——Ì«¶àÁË£¬ÕâÀï¾Í²»ËµÁË¡£»¹ÓУ¬Èç¹ûÄãÔÚSQL ServerÉϹ¤×÷£¬
 ÄÇôʹÓÃÕâЩ˽ÓеÄÀ©Õ¹ÊÇÓкô¦µÄ¡£ÓÉÓÚÐí¶àSQL ServerµÄÌØÐԵı¾ÖÊ£¬Ä㲻ʹÓ÷DZê×¼µÄÃüÁîµÄ»°£¬
 ½«»áÓкܶàÇ¿´óµÄ¹¦ÄÜÎÞ·¨ÊµÏÖ¡£Èç¹ûÄãÏëÒª¿´¿´ÄãµÄSQLÊÇ·ñ·ûºÏ±ê×¼£¬Äã¿ÉÒÔʹÓÃSET FIPS_FLAGGER
 ÃüÁî
 */
  SET FIPS_FLAGGER 'level'
/*
' level '
¶Ô FIPS 127-2 ±ê×¼µÄ×ñ´Ó¼¶±ð£¬½«¼ì²éËùÓÐÊý¾Ý¿â²Ù×÷ÊÇ·ñ´ïµ½¸Ã¼¶±ð¡£Èç¹ûÊý¾Ý¿â²Ù×÷ÓëÑ¡¶¨µÄ ISO ±ê×¼¼¶±ð³åÍ»£¬Ôò Microsoft SQL Server ½«Éú³ÉÒ»¸ö¾¯¸æ¡£
level ±ØÐëÊÇÏÂÁÐÖµÖеÄÒ»¸ö¡£
Öµ  ˵Ã÷  
ENTRY  ¼ì²éÊÇ·ñ×ñ´Ó ISO ÈëÃż¶±ê×¼¡£
 
FULL
 ¼ì²éÊÇ·ñ×ñ´Ó ISO ÍêÈ«¼¶±ê×¼¡£
 
INTERMEDIATE ¼ì²éÊÇ·ñ×ñ´Ó ISO Öм伶±ê×¼¡£
 
OFF
 ²»¼ì²éÊÇ·ñ×ñ´Ó±ê×¼¡£
*/
/*
SET FIPS_FLAGGER µÄÉèÖÃÊÇÔÚ·ÖÎöʱÉèÖ㬶ø²»ÊÇÔÚÖ´ÐлòÔËÐÐʱÉèÖá£ÔÚ·ÖÎöʱ½øÐÐÉèÖÃÒâζ×Å£ºSET Óï¾äÖ»Òª³öÏÖÔÚÅú´¦Àí»ò´æ´¢¹ý³ÌÖм´ÉúЧ£¬Óë´úÂëÖ´ÐÐʵ¼ÊÉÏÊÇ·ñµ½´ï¸ÃµãÎ޹أ»²¢ÇÒ SET Óï¾äÔÚÈκÎÓï¾äÖ´ÐÐ֮ǰÉúЧ¡£ÀýÈ磬¼ÙÉè SET Óï¾äÔÚ IF...ELSE Óï¾ä¿éÖУ¬¶øÔÚÖ´Ðйý³ÌÖдÓδµ½´ï¹ý¸ÃÓï¾ä¿é£¬µ«ÓÉÓÚ·ÖÎöÁË IF...ELSE Óï¾ä¿é£¬Òò´Ë SET Óï¾äÈÔÉúЧ¡£
Èç¹ûÔÚ´æ´¢¹ý³ÌÖÐÉèÖà SET FIPS_FLAGGER£¬Ôò´Ó´æ´¢¹ý³Ì·µ»Ø¿ØÖƺ󽫻¹Ô­ SET FIPS_FLAGGER µÄÖµ¡£Òò´Ë£¬ÔÚ¶¯Ì¬ SQL ÖÐÖ¸¶¨µÄ SET FIPS_FLAGGER Óï¾ä¶Ô¶¯Ì¬ SQL Óï¾äÖ®ºóµÄÈκÎÓï¾äÎÞЧ¡£
*/


Ïà¹ØÎĵµ£º

MSSQLÊý¾ÝÀàÐͼ°³¤¶ÈÏÞÖÆÏêϸ˵Ã÷

SQL Server ÌṩϵͳÊý¾ÝÀàÐͼ¯£¬¶¨ÒåÁË¿ÉÓë SQL Server Ò»ÆðʹÓõÄËùÓÐÊý¾ÝÀàÐÍ¡£ÏÂÃæÁгöϵͳÌṩµÄÊý¾ÝÀàÐͼ¯¡£
¿ÉÒÔ¶¨ÒåÓû§¶¨ÒåµÄÊý¾ÝÀàÐÍ£¬ÆäÊÇϵͳÌṩµÄÊý¾ÝÀàÐ͵ıðÃû¡£ÓйØÓû§¶¨ÒåµÄÊý¾ÝÀàÐ͵ĸü¶àÐÅÏ¢£¬Çë²Î¼û sp_addtype ºÍ´´½¨Óû§¶¨ÒåµÄÊý¾ÝÀàÐÍ¡£
µ±Á½¸ö¾ßÓв»Í¬Êý¾ÝÀàÐÍ¡¢ÅÅÐò¹æÔò¡¢¾«¶È¡¢Ð¡ÊýλÊý»ò³ ......

How is MSSQL using memory?


How is MSSQL using memory?
http://www.sqlhacks.com/Administration/Memory-Usage
Memory is one the most important factor affecting MSSQL performance.
As an administrator, you should be monitoring the memory
regularly. When Microsoft SQL Server runs out of memory, it will use
virtual memory: ie: ......

php µ÷ÓÃmssql´æ´¢¹ý³ÌʵÀýÓ¦ÓÃ

php½Ì³Ì µ÷ÓÃmssql´æ´¢¹ý³ÌʵÀýÓ¦ÓÃ
ÓÃmssql_initÓï¾äÓÃÓÚ³õʼ»¯´æ´¢¹ý³Ì£¬¶øºóµ÷ÓÃmssql_bindÓï¾äÖ¸¶¨´æ´¢¹ý³Ì²ÎÊý£¬×îºóµ÷ÓÃmssql_executeÖ´Ðд洢¹ý³Ì¡£
*/
//Á¬½ÓmssqlÊý¾Ý¿â½Ì³Ì·þÎñÆ÷
 $link = mssql_connect("127.0.0.1", "sa", "sa") or die("Can't connect sql server");
    mssql_sele ......

ÆôÓÃMSSQL·Ö²¼Ê½ÊÂÎñµÄ³£¼ûÎÊÌâ

ÈçºÎ´´½¨Á´½Ó·þÎñÆ÷
IF  EXISTS (SELECT srv.name from sys.servers srv WHERE srv.server_id != 0 AND srv.name = N'Á´½Ó·þÎñÆ÷Ãû')
EXEC master.dbo.sp_dropserver @server=N'Á´½Ó·þÎñÆ÷Ãû'', @droplogins='droplogins'
GO
EXEC master.dbo.sp_addlinkedserver
 @server = N'Á´½Ó·þÎñÆ÷Ãû'', @srvproduct= ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ