推薦：由于文件組 ‘DEFAULT’ 中的磁盤空間不足，無法為數據庫 ‘TEMPDB’ 分配新頁
今天接到一個朋友的問題，sql server報由于文件組 DEFAULT 中的磁盤空間不足，無法為數據庫 TEMPDB 分配新頁，按照錯誤提示應該是tempdb空間不足，讓其查看tempdb對應數據庫文件大小為不到4g，查看其對應文件為自增長，硬盤空間還有40g多點，那應該沒有問題。后來她說

 　　一.出現EXP-00091錯誤

　　[oracle@localhost tmp]$ exp "'/ as sysdba'" tables=testxuchao.TAB_XN_PY_DICT \

　　> file=/tmp/xifenfei.dmp log=/tmp/xifenfei.log

　　Export: Release 9.2.0.4.0 - Production on Mon Jan 16 16:02:37 2012

　　Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

　　Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production

　　With the Partitioning, OLAP and Oracle Data Mining options

　　JServer Release 9.2.0.4.0 - Production

　　Export done in US7ASCII character set and AL16UTF16 NCHAR character set

　　server uses ZHS16GBK character set (possible charset conversion)

　　About to export specified tables via Conventional Path ...

　　Current user changed to TESTXUCHAO

　　. . exporting table TAB_XN_PY_DICT 25433 rows exported

　　EXP-00091: Exporting questionable statistics.

　　EXP-00091: Exporting questionable statistics.

　　Export terminated successfully with warnings.

　　當環境變量和數據庫的不一致，在導出統計信息時候，會報EXP-00091錯誤。

　　二.查看NLS相關參數

　　[oracle@localhost tmp]$ echo $NLS_LANG

　　AMERICAN

　　SQL> col value for a30

　　SQL> select parameter,value from nls_database_parameters

　　2 where parameter like '%CHARACTERSET%';

　　PARAMETER VALUE

　　------------------------------ ------------------------------

　　NLS_CHARACTERSET ZHS16GBK

　　NLS_NCHAR_CHARACTERSET AL16UTF16

　　三.解決方法

　　1.設置NLS_LANG為NLS_CHARACTERSET

　　[oracle@localhost tmp]export NLS_LANG=american_america.ZHS16GBK

　　[oracle@localhost tmp]$ exp "'/ as sysdba'" tables=testxuchao.TAB_XN_PY_DICT \

　　> file=/tmp/xifenfei.dmp log=/tmp/xifenfei.log

　　Export: Release 9.2.0.4.0 - Production on Mon Jan 16 16:08:10 2012

　　Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

　　Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production

　　With the Partitioning, OLAP and Oracle Data Mining options

　　JServer Release 9.2.0.4.0 - Production

　　Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set

　　About to export specified tables via Conventional Path ...

　　Current user changed to TESTXUCHAO

　　. . exporting table TAB_XN_PY_DICT 25433 rows exported

　　Export terminated successfully without warnings.

　　2.使用statistics=none

　　[oracle@localhost tmp]$ exp "'/ as sysdba'" tables=testxuchao.TAB_XN_PY_DICT \

　　> file=/tmp/xifenfei.dmp log=/tmp/xifenfei.log statistics=none

　　Export: Release 9.2.0.4.0 - Production on Mon Jan 16 16:08:53 2012

　　Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

　　Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production

　　With the Partitioning, OLAP and Oracle Data Mining options

　　JServer Release 9.2.0.4.0 - Production

　　Export done in US7ASCII character set and AL16UTF16 NCHAR character set

　　server uses ZHS16GBK character set (possible charset conversion)

　　About to export specified tables via Conventional Path ...

　　Current user changed to TESTXUCHAO

　　. . exporting table TAB_XN_PY_DICT 25433 rows exported

　　Export terminated successfully without warnings.

分享：sqlserver多版本查看版本號
今天要查詢自己的裝的sqlserver2008 是否是R2版本，搜索了下，發現很多人查詢此問題，現在記錄如下，通過版本命令查詢 同時也了解了哥哥sql server的對應版本好，一看就非常清晰了,記錄下 1、查看 SQL Server 2005/2008 版本號 select serverproperty('productversion'