• christophe.bernard 47659 - Wednesday, February 14, 2018 2:45 AM

    Hello all,
    thanks for your reply and sorry for this delay ..

    @eirikur => sorry but my knowledge are basic ...how mucj traffic  / I/O performance ...
    i don't know actually how to get this information but i'm search 

    @sue => yes i'm agree ...no of course i can make a select top 100 for exemple but when i'm go to the production system for to search in the system
    i don't know the structure of the table i need to search ...and in fact if i made a select => that's tell we need to check because something are strange ....
    but next time, i will make a TOP 🙂

    i'm trying to get more information and become with that

    If all you want to know are things like column names and datatypes, then use sp_help 'tablename'.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)