 公告 |
03 2010 档案摘要: 查找未使用的非聚集索引和未使用的表.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 阅读(258) | 评论 (0) 编辑 | 摘要: 原文：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...阅读全文 posted @ 2010-03-29 10:32 nzperfect 阅读(406) | 评论 (0) 编辑 | 摘要: 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 阅读(367) | 评论 (0) 编辑 | 摘要: 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 阅读(127) | 评论 (0) 编辑 | 摘要: 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 阅读(1073) | 评论 (0) 编辑 | 摘要: 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 阅读(201) | 评论 (0) 编辑 | 摘要: 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 阅读(61) | 评论 (0) 编辑 | 摘要: 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 阅读(319) | 评论 (0) 编辑 | 摘要: 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 阅读(233) | 评论 (0) 编辑 |
|
|
