My Blog List

Sunday, July 12, 2009

PeopleSoft Application upgrade – Delete non PS statistics, SQL Server

SELECT sysobj.NAME TableName, stat.name StatisticsName
FROM sys.stats stat, SYSOBJECTS sysobj
WHERE stat.object_id = sysobj.ID
AND ( substring(stat.name,1,2) <> 'PS' AND substring(stat.name,2,2) <> 'WA')
AND sysobj.NAME like 'PS\_%' ESCAPE '\'

No comments: