11 2010 档案
Query Performance Tuning (SQL Server Compact)
摘要:Improve Indexes Creating useful indexes is one of the most important ways to achieve better query performance. Useful indexes help you find data with fewer disk I/O operations and less system resource... 阅读全文
posted @ 2010-11-18 08:43 大斌锅 阅读(551) 评论(0) 推荐(0)
Clear Analysis Services (SSAS) database cache
摘要:Example of command to clear cache for database:<ClearCache xmlns="http://schemas.microsoft.com/analysisservices/2003/engine"><Object><DatabaseID>Adventure Works DW</DatabaseID>... 阅读全文
posted @ 2010-11-12 12:00 大斌锅 阅读(316) 评论(1) 推荐(0)