- 博客(11)
- 资源 (1)
- 收藏
- 关注
转载 Checking to make sure a SQL Server backup is useable
http://www.mssqltips.com/sqlservertutorial/113/checking-to-make-sure-a-sql-server-backup-is-useable/
2014-06-19 14:31:25 660
转载 超棒的介绍DBCC PAGE的blog
http://www.mssqltips.com/sqlservertip/1578/using-dbcc-page-to-examine-sql-server-table-and-index-data/
2014-06-18 14:37:42 1028
转载 查询最后修改表中数据的时间
如果表没有resys.dm_db_index_usage_statshttp://msdn.microsoft.com/en-us/library/ms188755.aspx
2014-06-06 16:17:36 1895
转载 Creating, detaching, re-attaching, and fixing a SUSPECT database
大神fixhttp://www.sqlskills.com/blogs/paul/creating-detaching-re-attaching-and-fixing-a-suspect-database/
2014-06-06 14:39:33 1190
转载 如何fix suspect mode in SQL Server
When DBCC CHECKDB detects a corruption error, a dump file (SQLDUMPnnnn.txt) is created in the SQL Server LOG directory (Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG). The dump file contains
2014-06-06 13:38:04 1633
转载 Database mail issue "Message: The read on the database failed"
http://blogs.msdn.com/b/sqlserverfaq/archive/2010/03/18/database-mail-failing-with-the-service-queue-externalmailqueue-is-currently-disabled-message.aspx
2014-06-06 13:30:15 2640
转载 Using EMERGENCY mode to access a RECOVERY PENDING or SUSPECT database
http://www.sqlskills.com/blogs/paul/search-engine-qa-4-using-emergency-mode-to-access-a-recovery-pending-or-suspect-database/
2014-06-06 13:28:08 1619
转载 Sql_Handle and Plan_Handle Explained
For batches, the SQL handles are hash values based on the SQL text. For database objects such as stored procedures, triggers or functions, the SQL handles are derived from the database ID, object ID,
2014-06-04 15:54:30 1724
转载 Storing UTF-8 data in VARCHAR or NVARCHAR?
http://social.msdn.microsoft.com/Forums/sqlserver/en-US/46cb4626-716f-4fd7-af49-4b6fe1e5b955/storing-utf8-data-in-varchar-or-nvarchar?forum=sqldriverforphp
2014-06-04 13:56:44 818
原创 What the difference between rebuild index and re-organize index?
to be continue...
2014-06-03 15:04:08 1198
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人