博客园  :: 首页  :: 新随笔  :: 联系 :: 订阅 订阅  :: 管理

03 2010 档案

查找未使用的非聚集索引和表 for sql server 2005/2008

摘要：查找未使用的非聚集索引和未使用的表.DMV:sys.dm_db_index_usage_statsThe counters are initialized to empty whenever the SQL Server (MSSQLSERVER) service is started. In addition, whenever a database is detached or is shut... 阅读全文

posted @ 2010-03-30 15:03 nzperfect 阅读(525) 评论(0) 推荐(0)

64bit sql server 2008 sp1 使用lock pages in memory 具体操作

摘要：原文：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 nzperfect 阅读(2753) 评论(0) 推荐(1)

Index related DMVs and DMFs - sys.dm_db_index_usage_stats

摘要：Index related DMVs and DMFs - sys.dm_db_index_usage_stats By : Dinesh Priyankara Oct 09, 2007 Examining statistics of indexes is usefulforoptimizingthe performance of queries. Statistics help us d... 阅读全文

posted @ 2010-03-25 16:59 nzperfect 阅读(1063) 评论(0) 推荐(0)

How to recreate the msdb database in SQL Server 2005

摘要：How to recreate the msdb database in SQL Server 2005? I've just spenta bunchtime researching an answer tothis question on the new disaster recovery forumbecause I couldn't find any definitive ... 阅读全文

posted @ 2010-03-24 17:48 nzperfect 阅读(381) 评论(0) 推荐(0)

Windows 7 RTM不能多用户同时登陆的解决方法

摘要：By Mike Garcen (ShadyMG) | Published Wednesday, 22 July 2009 In honor of Windows7 hitting the big RTM (release to manufacturing) milestone, I figured it best to start fresh with this Guide and archive... 阅读全文

posted @ 2010-03-13 19:06 nzperfect 阅读(1633) 评论(0) 推荐(0)

SQL Server Memory Configuration, Determining MemToLeave Settings

摘要：Determining the appropriate memory configuration for a SQL Server platform is a task that all database administrators are required to perform. It is essential to ensuring that an appropriate level o... 阅读全文

posted @ 2010-03-12 14:48 nzperfect 阅读(719) 评论(0) 推荐(0)

基础回顾:What are the difference between DDL, DML and DCL commands?

摘要：What are the difference between DDL, DML and DCL commands? DDL is Data Definition Language statements. Some examples: CREATE - to create objects in the database ALTER - alters the structure of the d... 阅读全文

posted @ 2010-03-04 10:53 nzperfect 阅读(212) 评论(0) 推荐(0)

64bit sql server 2005 /2008 标准版支持锁定内存页更新补丁

摘要：An update for Standard SKU Support for Locked Pages…. Note this article has been updated to include an update for SQL Server 2005 I posted in April that we would be releasing cumulative update... 阅读全文

posted @ 2010-03-03 17:37 nzperfect 阅读(615) 评论(0) 推荐(0)

[转]Fun with Locked Pages, AWE, Task Manager, and the Working Set…

摘要：Fun with Locked Pages, AWE, Task Manager, and the Working Set… I realize that the topic of “locked pages’ and AWE can be confusing. I don’t blame anyone for being confused on... 阅读全文

posted @ 2010-03-03 17:30 nzperfect 阅读(724) 评论(0) 推荐(0)