摘要: if not exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tablespaceinfo]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) create table t 阅读全文
posted @ 2020-06-13 11:04 尼哈 阅读(441) 评论(0) 推荐(0) 编辑
摘要: select * from (SELECT user_seeks * avg_total_user_cost * ( avg_user_impact * 0.01 ) AS [index_advantage] , dbmigs.last_user_seek , dbmid.[statement] A 阅读全文
posted @ 2020-06-13 10:27 尼哈 阅读(642) 评论(0) 推荐(0) 编辑