Fanr

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

2011年4月1日

摘要: I have a client that was in need of moving all there indexes from the primary file group to an index file group. There were a total of 25 databases so the time needed to script each one individually would have been overwhelming not to mention the need to perform this across multiple environments.I s 阅读全文
posted @ 2011-04-01 13:46 Fanr_Zh 阅读(328) 评论(0) 推荐(0) 编辑

摘要: Introductionsp_who2 is a well known utility that shows what spids are currently executing. However the information it shows is relatively limited. For example, it only shows the type of command executing as SELECT, DELETE etc, with no reference to the actual underlying SQL executing.Knowing what SQL 阅读全文
posted @ 2011-04-01 12:50 Fanr_Zh 阅读(1172) 评论(0) 推荐(0) 编辑