Move to Production
Saturday, July 18, 2009
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 '\'
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 '\'
Subscribe to:
Posts (Atom)
