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

Ö´ÐÐSQLÈ¡PostgreSQLÊý¾Ý¿â»ò±í´óС

ÔÚPostgreSQL8.1.3ÉÏ¿ÉÒÔwork
1. È¡Êý¾Ý¿â´óС
SELECT pg_size_pretty(pg_database_size('somedatabase')) As fulldbsize
2. È¡±í´óС
SELECT pg_size_pretty(pg_total_relation_size('someschema.sometable')) As fulltblsize, pg_size_pretty(pg_relation_size('someschema.sometable')) As justthetblsize
Ô­Ìù£º
http://www.postgresonline.com/journal/index.php?/archives/110-Determining-size-of-database,-schema,-tables,-and-geometry.html


Ïà¹ØÎĵµ£º

Oracle:pl/sql Òì³£´¦Àí[ת]


pl/sql ÌṩÁËÇ¿´ó¶øÁé»îµÄÊÖ¶ÎÀ´²¶×½ºÍ´¦Àí³ÌÐò²úÉúµÄÒì³££¬´Ó¶øÊ¹ oracle µÄÓû§Ô¶ÀëһЩÁîÈË·³ÄÕµÄ bug ¡£
 
pl/sql Òì³£´¦ÀíµÄ¸ÅÄîºÍÊõÓï
 
ÔÚ oracle ÖÐËùÓеĴíÎó¶¼±»ÈÏΪÊDz»Ó¦¸Ã·¢ÉúµÄÒì³£¡£Ò»¸öÒì³£¿ÉÄÜÊÇÒÔÏ 3 ÖÖÇé¿öµÄÒ»ÖÖ£º
u       ÓÉϵͳ²úÉúµÄ´íÎó£¨& ......

SQL Server 2000µÄJDBCÁ¬½ÓÎÊÌâ½â¾ö·½·¨

 ¾­¹ýºÃ¼¸ÌìµÄ·ÜÕ½£¬JDBCÖÕÓڳɹ¦Á¬½ÓÁËSQL Server 2000£¬ÆÚ¼ä×ßÁ˲»ÉÙÍä·£¬ÔÚÕâÀï·ÖÏíÎÒµÄÒ»µã¾­Ñé
Ò»¡¢ÎҵĻ·¾³
   Windows XP+JDK6u15+Microsoft SQL Server 2000£¨SP4£©+JCreator
   ÎÒÏÈÔÚÍøÉÏÏÂÔØÊý¾Ý¿âÇý¶¯³ÌÐò£¬Ä¿Â¼ÏÂÓÐÈý¸ö°ümsbase.jar mssqlserver.jar msutil.jar
   1 ......

Sql Server2005ʵÏÖÔ¶³Ì±¸·ÝÊý¾Ý¿â

 
ÏàÐÅ´ó¼Ò¶¼ÔÚµ±ÐÄÊý¾Ý¿âµÄ¶ªÊ§£¬ÕâÒ²ÊÇÿ¸ö¿ª·¢ÕßÍ·Í´µÄÒ»¼þʼþ£¬ÒòΪÕýÔÚÔËÐеķþÎñÆ÷¼°Êý¾Ý¿âÒ²ÔÚÕą̂·þÎñÆ÷ÉÏ¡£Èç¹û·þÎñÆ÷±ÀÀ££¬ÄÇôËùÓеÄÊý¾Ý
¶¼²»´æÔÚÁË£¬¾ÍËãÊÇÄãÔÚÄãµÄ»ú×ÓÉÏ×öÁ˱¸·Ý£¬ÄÇÒ²ÊÇûÓÐÓõģ¬ÎªÊ²Ã´»áÕâÑù˵Ö÷ÒªÊÇÒòΪ±¾»úÊÇÏò»¥ÁªÍø¹«¿ªµÄ£¬ËùÒÔ³öʹʵĸÅÂʾͱȽϸߡ£×îÖÕÎÒÃÇ¿ÉÒÔÀû
ÓþÖÓò ......

SQL Server Ë«»úÈȱ¸1(based on log shipping)

        ÈÕÖ¾´«ËÍÊÇSQL SERVER2000ÆóÒµ°æ½øÐÐË«»úÈȱ¸µÄÒ»¸öÖ÷Òª½â¾ö·½°¸£¬ÆäÔ­Àí±È½Ï¼òµ¥£¬ÊµÏÖÒ²±È½Ï·½±ã£¬Ö»ÊÇÓÉÓÚºÍWindowsÖ®¼ä´í×Û¸´ÔӵĹØÏµ£¬µ¼ÖÂÉèÖÃÆðÀ´Óв»ÉÙÀ§ÄÑ£¬³öÏÖÎÊÌâÒ²²»ÈÝÒ×Õï¶Ï¡£
1.ʵÏÖ¸ÅÊö
 *Ë«»úÈȱ¸Õë¶ÔµÄÊǾßÌåµÄij¸öÊý¾Ý¿â¶ø²»ÊÇÕû¸ö·þÎñÆ÷
 Ë«» ......

½â¾öSQL Server 1069´íÎó:µÇ¼ʧ°Ü

SQL Server ·þÎñÓÉÓڵǼʧ°Ü¶øÎÞ·¨Æô¶¯
1.Ö¢×´
ÔÚÖØÐÂÆô¶¯ SQL Server¡¢SQL Executive »ò SQL Server Agent ʱ£¬¿ÉÄÜÎÞ·¨Æô¶¯¸Ã·þÎñ£¬²¢ÏÔʾÒÔÏ´íÎóÐÅÏ¢£º
Error 1069:The service did not start due to a logon failure.
»òÕß
´íÎó 1069£ºÓÉÓڵǼʧ°Ü¶øÎÞ·¨Æô¶¯·þÎñ
2.Ô­Òò
SQL Server¡¢SQL Agent »ò SQL Serve ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ