随笔分类 - MSSQL 数据库维护
摘要：/*该脚本示例如何完整的修改一个数据库的名称.数据库为原名称为DB_BEIJING，需要修改成DB_SHANGHAInzperfect 2012.12.19*/--判断是否存在同名的数据库，以防止误删除USE masterGOIF EXISTS (SELECT name FROM sys.databases WHERE name = N'DB_BEIJING')BEGIN RAISERROR('请注意：数据库已存在！',15,1) RETURN --DROP DATABASE DB_BEIJINGENDGOUSE masterGO--创建测试数库CREATE D
阅读全文
posted @ 2012-12-19 17:42
摘要：来自：msdn论坛贴子创建一个测试表TESTTABLE,并且插入如下两行数据:insertinto TESTTABLE values (1, 'aaaa')insertinto TESTTABLE values (2, 'bbbb')然后做如下的操作。update TESTTABLEset myName = 'cccc' where myID = 2为了更加直观化，我们可以用一些日志工具如ApexSQL Log (从http://www.apexsql.com/ ) 可以下载来观察一下日志的结构。这时候，我们可以看到，update的语句包含了ol
阅读全文
posted @ 2012-02-21 10:16
摘要：EXEC sp_resetstatus 'DBname';ALTER DATABASE DBname SET EMERGENCYDBCC checkdb('DBname')ALTER DATABASE DBname SET SINGLE_USER WITH ROLLBACK IMMEDIATEDBCC CheckDB ('DBname', REPAIR_ALLOW_DATA_LOSS)ALTER DATABASE DBname SET MULTI_USER参考：http://www.codeproject.com/KB/reporting-ser
阅读全文
posted @ 2011-06-16 15:56
摘要：http://connect.microsoft.com/SQLServer/feedback/details/334180/data-collector-remove-data-collector-to-remove-associated-objectsAfter the data collector is configured, the data collector can be disabled but not removed. This means that all objects created by the data collector will remain on the ins
阅读全文
posted @ 2010-12-22 16:21
摘要：原文：http://blogs.msdn.com/suhde/archive/2009/05/20/lock-pages-in-memory-now-available-for-standard-edition-of-sql-server.aspxDue to over-whelming customer demand for the "Lock pages in memory" support for the Standard Edition of SQL Server 2005 and 2008, Microsoft has released Cumulative Up
阅读全文
posted @ 2010-03-29 10:32
|
||
