Post reply

Script for joins

  • November 2, 2011 at 4:27 am

    #247041

    Hi,

    Is there a way I can get all the inner joins that are in a particular db? Is there a dmv that can do this?

    Thanks

  • November 2, 2011 at 4:39 am

    #1402051

    If you have foreign keys you can build a script based on that.

    Anything else you can think of is just a guess / incomplete picture.

    You could extract all the plans from the cache & parse them to pick out the joins but untill and unless you can be 100% sure that all possible code pathways are in the plan cache & nothing has been deleted & no expections are missing, you just have a partial view of the DB.

  • November 2, 2011 at 4:40 am

    This was removed by the editor as SPAM

  • November 2, 2011 at 5:56 am

    #1402083

    Yep for a particular db.

  • November 2, 2011 at 6:11 am

    This was removed by the editor as SPAM

  • November 3, 2011 at 3:31 am

    #1402540

    Thanks

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply