SQL Server??????
???????????? ???????[ 2013/4/10 9:57:43 ] ????????
???????????????
?????????????????
?????????????????????????????????????????к??????????????????????????????????????????????????????????SQLServer????????????????????????where??on????????????????????????????????????????????????????????????з??????????????????????л????Щ?????????????
??????????????????SQLServer??????????????????????????????????????????????????????????????????????
?????????????
??????????????????????????/?????????????
??????????????????????????????????????1?????????????????????????
?????????????????????
????????????????SQLServer?????????????????????????????????SELECT?????????????????????????????
????1????????????????????
????2????????????????????
?????????????
??????????????????????β??????????????????????
SELECT CASE WHEN DATABASEPROPERTYEX('master'?? 'IsAutoCreateStatistics') = 1
THEN 'Yes'
ELSE 'No'
END AS 'IsAutoCreateStatistics?' ??
CASE WHEN DATABASEPROPERTYEX('Master'?? 'IsAutoUpdateStatistics') = 1
THEN 'Yes'
ELSE 'No'
END AS 'IsAutoUpdateStatistics?' ??
CASE WHEN DATABASEPROPERTYEX('Master'?? 'Is_Auto_Update_stats_async_on') = 1
THEN 'Yes'
ELSE 'No'
END AS 'IsAutoUpdateStatsaAyncOn?'
GO
???????????????????where????е??????????????????????
SELECT object_id ??
OBJECT_NAME(object_id) AS TableName ??
name AS StatisticsName ??
auto_created
FROM sys.stats
--where object_id=OBJECT_ID('Sales.SalesOrderHeader')
ORDER BY object_id DESC
GO
??????
???·???
??????????????????
2023/3/23 14:23:39???д?ò??????????
2023/3/22 16:17:39????????????????????Щ??
2022/6/14 16:14:27??????????????????????????
2021/10/18 15:37:44???????????????
2021/9/17 15:19:29???·???????·
2021/9/14 15:42:25?????????????
2021/5/28 17:25:47??????APP??????????
2021/5/8 17:01:11