Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. Database & SysAdmin
  3. Database
  4. prior action plan to prevent sql database corruption

prior action plan to prevent sql database corruption

Scheduled Pinned Locked Moved Database
database
5 Posts 4 Posters 38 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • K Offline
    K Offline
    Kar_Malay
    wrote on last edited by
    #1

    prior action plan to prevent sql database corruption DISTINCT alternatives in sql query conversion of query scan to seek

    Richard Andrew x64R J 2 Replies Last reply
    0
    • K Kar_Malay

      prior action plan to prevent sql database corruption DISTINCT alternatives in sql query conversion of query scan to seek

      Richard Andrew x64R Offline
      Richard Andrew x64R Offline
      Richard Andrew x64
      wrote on last edited by
      #2

      You should try writing in complete sentences if you want an answer to your question(s).

      The difficult we do right away... ...the impossible takes slightly longer.

      D 1 Reply Last reply
      0
      • Richard Andrew x64R Richard Andrew x64

        You should try writing in complete sentences if you want an answer to your question(s).

        The difficult we do right away... ...the impossible takes slightly longer.

        D Offline
        D Offline
        Dave Kreskowiak
        wrote on last edited by
        #3

        His first post was like this one, 3 years ago, and he still hasn't learned how to completely express ideas in complete sentences.

        Asking questions is a skill CodeProject Forum Guidelines Google: C# How to debug code Seriously, go read these articles.
        Dave Kreskowiak

        1 Reply Last reply
        0
        • K Kar_Malay

          prior action plan to prevent sql database corruption DISTINCT alternatives in sql query conversion of query scan to seek

          J Offline
          J Offline
          jschell
          wrote on last edited by
          #4

          Kar_Malay wrote:

          database corruption

          The term "corruption" applies to the data that is stored by the database server and has nothing to do with valid/possible structuring of tables. Which your other two points would seem to suggest. Preventing inconsistent data, orphans, etc is not something that anyone is going to cover in an online post. Buy yourself a database book or several (beginning and advanced) and read them before you start designing anything.

          K 1 Reply Last reply
          0
          • J jschell

            Kar_Malay wrote:

            database corruption

            The term "corruption" applies to the data that is stored by the database server and has nothing to do with valid/possible structuring of tables. Which your other two points would seem to suggest. Preventing inconsistent data, orphans, etc is not something that anyone is going to cover in an online post. Buy yourself a database book or several (beginning and advanced) and read them before you start designing anything.

            K Offline
            K Offline
            Kar_Malay
            wrote on last edited by
            #5

            yes, that's true got good result by reconstructing database, eliminating unnecessary open connections, creating missing index, converting scan to seek, minimizing scan re-looping, distinct elimination / avoidant etc. thanks

            1 Reply Last reply
            0
            Reply
            • Reply as topic
            Log in to reply
            • Oldest to Newest
            • Newest to Oldest
            • Most Votes


            • Login

            • Don't have an account? Register

            • Login or register to search.
            • First post
              Last post
            0
            • Categories
            • Recent
            • Tags
            • Popular
            • World
            • Users
            • Groups