Hi All,
One of my fellow dba asked a question.
I have a database having multiple schema's in it. I want to update statistics for some specific schema's only?
Now how to do that. Again SP_MSFOREACHTABLE (ofcourse non documented) but the savior here.
--This will print table names first for specific schema.
Exec sp_MSforeachtable @command1 = " print '?' ", @whereand = " and uid = (SELECT schema_id FROM sys.schemas WHERE name = 'dbo') "
--This will update statistics for specific schema.
Exec sp_MSforeachtable @command1 = " Update Statistics ? ", @whereand = " and uid = (SELECT schema_id FROM sys.schemas WHERE name = 'sales') "
So using above command we can do this. If we have multiple schema's simply change Where condition and make it WHERE NAME in ('a','b','c')
