Muhammad Abbas - Data Engineering Architect
Pages
CV
Profile
BLOG
Search This Blog
Showing posts with label
stats
.
Show all posts
Showing posts with label
stats
.
Show all posts
Monday, September 20, 2010
[T-SQL] Find Auto Created Stats and Delete query for them
Query for getting them:
SELECT name, OBJECT_NAME(OBJECT_ID)
FROM sys.stats
WHERE auto_created = 1;
Delete query for one of the table stats:
DROP STATISTICS TableName.StatisticsName
Older Posts
Home
Subscribe to:
Posts (Atom)