Post reply

how to optimise whole database full of table and sp in one go using githubcopilo

  • September 11, 2025 at 9:19 am

    #4649858

    i have subscription of github copilot which i can access in vs 2022 comunity edition.

    i have been optimising my tsql in vs 2022 using githubcopilot.

    now i need to optimise my whole database which has many tables and sps.

  • September 11, 2025 at 10:28 am

    #4649901

    Trying to optimize something just because is like trying to skate uphill into a blizzard.

    As Brent Ozar keeps reminding us ... "What problem are you trying to solve?"

    Every optimization comes at the expense of something else.

     

    Also, in my limited experience, AI does not do too well with bulk tasks.  You need to know exactly what you want, and direct AI carefully to achieve your expected outcome.

    How to post data/code on a forum to get the best help.

  • September 11, 2025 at 11:18 am

    #4649928

    i need to know  how AI can do that bulk tasks which u mentioned.

     

  • September 11, 2025 at 12:26 pm

    #4649953

    i have seen DTA can take table as input, but somebody said only one statement can be put in side the workload tables' one row.

    i need to anaylise all storeprocedures in one go. how can do it.

Viewing 4 posts - 1 through 4 (of 4 total)

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