BTW, I cleared all the EstimatedCounts and PartitionCounts as they are not recomputed if they exist. I have also tried deleting the Aggregations and redoing.

As an aside, I was...

Go to Amazon and get MCTS Exam 70_448. It comes with a companion CD and pretty good lessons. It's not to indepth but will get you started with...

Ok all, I wrote a stored procedure to return the rows where a string is a bad guid.

Just pass in DBName, TableName, FieldToTest if contents are guid, KeyField (underlying ID...

Once for now to populate values in table, but might need to be repeatable. I figured out a two step process to do by selecting into a table and...

Thanks for reply but it has to be a uniqueidentifier.

Thanks Jeff, I had not seen that article. Very well written and great explanation.

I can't add any indexes to database. I'm just a lowly contractor, so I have to get as much speed as possible with what I have. There's 16m...

Thanks Lutz.

DerBeDer, sometimes I am a doofii (plural of doofus). ie. My thought patterns are so linear. Don't know why I did not think of...