Home Forums SQL Server 2008 SQL Server 2008 - General A Database with 70 Table RE: A Database with 70 Table

  • September 18, 2012 at 4:51 pm

    #1539324

    vahid.arr (9/18/2012)

    hi everybody

    I Have Database With 70 Tables and this my first time that i have alot table in my DB. I want Any Subject or Topic that is Good for me With This situation Secuirity or optimization or etc.

    Heh... it's easy... deny privs to everyone except to execute stored procedures while this DB is still small enough to "take control" like this. 😉

    --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)