Thanks for the article. This looks like something I need to try in the lab.

Great article.

So, do you find this a better option than using a data conversion transformation, or just a different option?

Everything is logged to a text file (using the SSIS log provider for Text files)

Argh, I should have been able to figure that out.

Thanks!

Perfect! Thanks.

Here's the final scripts

$s = "kbullen-865";

$db_name = "tempdb";

$CombinedExceptionMessage = "";

##Add-Type -Path "C:\Program Files (x86)\Microsoft SQL Server\100\SDK\Assemblies\Microsoft.SqlServer.Smo.dll"

[System.Reflection.Assembly]::LoadWithPartialName('Microsoft.SqlServer.SMO') | Out-Null

$serv = New-Object Microsoft.SqlServer.Management.SMO.Server($s)

Function CheckObject

{

Param...

Yeah, i know, the conversation is years old. But SQLCop and Red Gate and everyone else looking to identify missing foreign key indexes should probably be reading this thread.

Yep, line 18 was supposed to be bad as well. I missed it.

Sorry 'bout that.

People around here questioned where Doc Jr and Doc Jr Jr came from....

Thanks for the reply.

The reason for the filter, I don't want to return the whole table. If I add a few more records, and only want Snow White...

Thanks for the info!

Thanks all for the input. I'm going to plan on leaving the backup\restore process in place and schedule the dbcc's on the second server and not schedule them on...

Thanks, after reading your post, I added an option recompile to the select and that fixed my problem.

Thanks for the response. I guess I thought it would be cool to use an unpivot, but the union works and after reading some additional posts on unpivot, maybe...

j.miner (4/8/2013)

---

Maybe I'm misunderstanding param sniffing, but isn't the optimizer going to generate a plan and keep it until something changes (index rebuilt\reorg, stats update, table records added\deleted, etc...), and...

Thank you all for taking time to reply, I appreciate all of the input.