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 Óï¾äÖ®ºóµÄÈκÎÓï¾äÎÞЧ¡£
*/
Ïà¹ØÎĵµ£º
SQL Server ÌṩϵͳÊý¾ÝÀàÐͼ¯£¬¶¨ÒåÁË¿ÉÓë SQL Server Ò»ÆðʹÓõÄËùÓÐÊý¾ÝÀàÐÍ¡£ÏÂÃæÁгöϵͳÌṩµÄÊý¾ÝÀàÐͼ¯¡£
¿ÉÒÔ¶¨ÒåÓû§¶¨ÒåµÄÊý¾ÝÀàÐÍ£¬ÆäÊÇϵͳÌṩµÄÊý¾ÝÀàÐ͵ıðÃû¡£ÓйØÓû§¶¨ÒåµÄÊý¾ÝÀàÐ͵ĸü¶àÐÅÏ¢£¬Çë²Î¼û sp_addtype ºÍ´´½¨Óû§¶¨ÒåµÄÊý¾ÝÀàÐÍ¡£
µ±Á½¸ö¾ßÓв»Í¬Êý¾ÝÀàÐÍ¡¢ÅÅÐò¹æÔò¡¢¾«¶È¡¢Ð¡ÊýλÊý»ò³ ......
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´æ´¢¹ý³ÌʵÀýÓ¦ÓÃ
ÓÃ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 ......
ÈçºÎ´´½¨Á´½Ó·þÎñÆ÷
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= ......