Not sure if this wil be readable. Keep in mind the deletion job I mentioned in my first post.

CacheTypeTotal PlansTotal MBsAvg Use CountTotal MBs – USE Count 1Total Plans...

Yes, something is inconsistent about this powershell scripting with SMO. With these options I get create statistic statements on about 12 tables where there are numerous statistics on many other...

For now I'd rather stick with powershell. I took The Simple Talk ( Phil Factor ) powershell script and adapted it. Then added an IF statement near the...

looks very useful, thanks.

Thanks John. I'll have to try that again. I did exactly that in profiler yesterday and the queries it revealed pulled back various info on the table, indexes,...

Conclusion: query plans to not reveal the string values supplied for a full text CONTAINS statement.

Interesting that in this plan there is a large variance between actual and estimated rows on one index seek on a table PK. Updating stats on that index...

I was going to run the query and get the actual plan but needed the "borrower name" strings used in the original.( full text index on that ) ...

plan attached

I use both xp_cmdshell and powershell. xp_cmdshell is usually for easier things that I pretty much already know how to do. I don't write powershell scripts from scratch,...

You may be able to do the same things with xp_cmdshell that you can do with powershell, but I think it's safe to say it would be considerably more...

Can we expect xp_fileExist to continue functioning? Isn't it undocumented?

How so? If you meant why use powershell over xp_cmdshell ( you probably didn't mean that ), the answer would be because it has so much more functionality.

If you...

So far I only recall trying to use powershell from a sql agent job once, but this might be a better route than xp_cmdshell.

I use xp_cmdshell in sql jobs, but turn it on before the action and turn it off after. The one that comes to mind is using DIR to check...