Page 1 of 2 12 LastLast
Results 1 to 15 of 24
  1. #1
    Join Date
    Nov 2005
    Location
    San Francisco, CA
    Posts
    506

    Unanswered: Simplest way to crash a sql server

    Hi,
    What is the simplest way to crash a sql server?
    Somebody asked me that question, and I was unable to give the best answer. Please help me to find it.
    Thanks!!
    Joydeep
    Success is the ability to go from one failure to another with no loss of enthusiasm.
    - Sir Winston Churchill
    Joydeep

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Shove it off the shelf.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  3. #3
    Join Date
    Nov 2005
    Location
    San Francisco, CA
    Posts
    506
    Quote Originally Posted by blindman
    Shove it off the shelf.
    Hey The Great B'man , u can't Shove it off the shelf man ,its a nice software not a hardware.
    Success is the ability to go from one failure to another with no loss of enthusiasm.
    - Sir Winston Churchill
    Joydeep

  4. #4
    Join Date
    Nov 2004
    Location
    on the wrong server
    Posts
    8,835
    Provided Answers: 6
    have application developers design the database and write all of the sql without any dba input review or feedback usually works .

    the baseball bat is usually good too.
    “If one brings so much courage to this world the world has to kill them or break them, so of course it kills them. The world breaks every one and afterward many are strong at the broken places. But those that will not break it kills. It kills the very good and the very gentle and the very brave impartially. If you are none of these you can be sure it will kill you too but there will be no special hurry.” Earnest Hemingway, A Farewell To Arms.

  5. #5
    Join Date
    Nov 2004
    Location
    on the wrong server
    Posts
    8,835
    Provided Answers: 6
    or let the business analyst connect with Access.

    or let the project manager use a report writer.

    or let the boss have admin access.
    “If one brings so much courage to this world the world has to kill them or break them, so of course it kills them. The world breaks every one and afterward many are strong at the broken places. But those that will not break it kills. It kills the very good and the very gentle and the very brave impartially. If you are none of these you can be sure it will kill you too but there will be no special hurry.” Earnest Hemingway, A Farewell To Arms.

  6. #6
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    Crash as in blue-screen the server? Or merely make the data unavailable? I think you need to write a few extended stored procedures for the blue screen. Or, you could write a startup stored procedure like this:

    Code:
    create procedure on_start
    as
    shutdown with nowait
    go
    That's a good one.

  7. #7
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    There was a question on SQL Team recently. Something along the lines of:

    "I right clicked my database and scripted a drop script for all the objects. I pasted this into query analyser and hit F5. Help! How can I get my database back?"

    Employing him\ her would be a good start.
    Testimonial:
    pootle flump
    ur codings are working excelent.

  8. #8
    Join Date
    Jan 2004
    Posts
    164
    [QUOTE=MCrowley]Crash as in blue-screen the server? Or merely make the data unavailable? I think you need to write a few extended stored procedures for the blue screen. Or, you could write a startup stored procedure like this:

    Code:
    create procedure on_start
    as
    shutdown with nowait
    go
    Thats a good one!

  9. #9
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Quote Originally Posted by Thrasymachus
    have application developers design the database and write all of the sql without any dba input review or feedback usually works .
    Oh, that beats mine hands-down. You are the sarcasm master. ROFLMAO and all that...
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  10. #10
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    Here is a sample from one of our newest "killer apps". Not sure who it is supposed to kill...

    Code:
    SQL> desc appuser.projectteam
     Name                                      Null?    Type
     ----------------------------------------- -------- --------------
     ID                                        NOT NULL NUMBER(10)
     NPIPROJECTSID                                      NUMBER(10)
     CREATOR                                            VARCHAR2(8)
     NPC                                                VARCHAR2(8)
     TESTDEVENGINEER                                    VARCHAR2(8)
     BRANDINSTPROVIDER                                  VARCHAR2(8)
     BONDDIAGRAMGENERATOR                               VARCHAR2(8)
     SAPMARKETINGADMIN                                  VARCHAR2(8)
     WWMFGTESTERENGINEER                                VARCHAR2(8)
     WWMFGASSYENGINEER                                  VARCHAR2(8)
     FORECASTER                                         VARCHAR2(8)
     PLANNER                                            VARCHAR2(8)
     ADGTFINANCEREP                                     VARCHAR2(8)
     BOMCOORDINATOR                                     VARCHAR2(8)
     MFGINDUSTRIALENG                                   VARCHAR2(8)
     MRPPLANNER                                         VARCHAR2(8)
     PICSCAPADMIN                                       VARCHAR2(8)
     WWDEVSITEOPSMANAGER                                VARCHAR2(8)
     WWMFGADGTFFMANAGER                                 VARCHAR2(8)
     WWMFGASSYECNENGINEER                               VARCHAR2(8)
     WWMFGCHUTEYIELDENG                                 VARCHAR2(8)
     WWMFGPACKENGINEER                                  VARCHAR2(8)
     WWMFGHANDLERENG                                    VARCHAR2(8)
     WWMFGQUALENGINEER                                  VARCHAR2(8)
     WWMFGOFFSHORETESTENG                               VARCHAR2(8)
     WWMFGFINANCE                              NOT NULL VARCHAR2(8)
     WWMFGTESTENGMANAGER                                VARCHAR2(8)
     DEVSITECOORDINATOR                                 VARCHAR2(8)
     WWMFGNPCOORDINATOR                                 VARCHAR2(8)
    
    SQL>
    Now, if you guessed that each field holds a user name, you too can write our next "killer app". I won't even start on the other tables. It's too early in the morning to have a coronary.

  11. #11
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Ohhhhhhhhh. It's Oracle. I thought someone had created a UDT and called it VarChar2. I thought we were into serious WTF territory.
    Testimonial:
    pootle flump
    ur codings are working excelent.

  12. #12
    Join Date
    Dec 2002
    Posts
    1,245
    Not sure about "crashing" a SQL server, but our vendor has managed to bring new work here to a grinding halt. The users table has a PK defined as
    Code:
    numeric(4,0)
    That's right, 9,999 users and then no more. On Monday we tried to add user number 10,000. No go.

    The best part is that this column is the base for 530 columns (give or take a few) in 230 tables and (almost) all are connected by FK constraints.

    So, to fix the problem?

    Drop all FK constraints pointing to this column
    Drop all indexes based on the columns in question
    Drop all unique constraints based on the related columns
    Change the column definitions
    Re-add unique constraints
    Re-add indexes
    Re-add FK constraints
    Tidy up miscelleneous tables/columns not explicitly related by FK constraints

    In the meantime, no new users can have access...

    Regards,

    hmscott

    PS. And the vendor said? "Oh, our dba is no longer here, can you help?"
    Have you hugged your backup today?

  13. #13
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Doesn't sound like he was much of a dba to begin with.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  14. #14
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    well, i don't know about crash, but this should certainly slow it down to a crawl --
    Code:
    select * from products, orderitems, orders, customers
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  15. #15
    Join Date
    Jan 2004
    Location
    In a large office with bad lighting
    Posts
    1,040
    unplug it from the ups!

    -- This is all just a Figment of my Imagination --

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •