#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2002
    Posts
    8
    Rep Power
    0

    some DBA questions


    Can someone answer following questions? Thanks a lot!

    6. Users report that the server has become non-responsive. What are the possible explanations, and how do you check out each one. Please answer in the order in which you judge it to be most reasonable to check this out. A terse columnar answer is acceptable.

    7. What are deadlocks? What Transact-SQL feature (or complexity) is normally required for them to occur, but how (why?) might they also occur in a simple situation?
  2. #2
  3. No Profile Picture
    Gödelian monster
    Devshed Regular (2000 - 2499 posts)

    Join Date
    Jul 1999
    Location
    Central Florida, USA
    Posts
    2,307
    Rep Power
    62
    Umm...

    We tend not to enjoy answering homework/test questions. Especially when they are just quoted verbatim. If you are actually working on a real-life problem, and have spent enough time on it to put it in your own words, then you are more likely to get an answer.

    Sorry
    The real n-tier system:

    FreeBSD -> PostgreSQL -> [any_language] -> Apache -> Mozilla/XUL

    Amazon wishlist -- rycamor (at) gmail.com
  4. #3
  5. Banned (not really)
    Devshed Supreme Being (6500+ posts)

    Join Date
    Dec 1999
    Location
    Brussels, Belgium
    Posts
    14,646
    Rep Power
    4492
    Aren't deadlocks those things some people do to their hair?

    ---John Holmes...

    Sorry, I don't know the answer to either one.
    -- Cigars, whiskey and wild, wild women. --
  6. #4
  7. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2002
    Posts
    409
    Rep Power
    13

IMN logo majestic logo threadwatch logo seochat tools logo