switchon@lavalamp.biz
+27(0) 83 419 4851 / +27(0) 21 036 1165
Application & software development
Get A Quote

    • Home
    • Services
      • Application & software development
      • Outsourced software development
      • Project based resourcing
      • Digital marketing & consulting
      • Graphic design & consulting
      • UI / UX design & consulting
      • Recruitment services
      • Lease an expert
    • About
      • How we work
      • NBConsult Group
      • Partners
      • Lightbox Digital
    • Blog
    • Join us
    • Contact

    • Home
    • Services
      • Application & software development
      • Outsourced software development
      • Project based resourcing
      • Digital marketing & consulting
      • Graphic design & consulting
      • UI / UX design & consulting
      • Recruitment services
      • Lease an expert
    • About
      • How we work
      • NBConsult Group
      • Partners
      • Lightbox Digital
    • Blog
    • Join us
    • Contact

    • Home
    • Services
      • Application & software development
      • Outsourced software development
      • Project based resourcing
      • Digital marketing & consulting
      • Graphic design & consulting
      • UI / UX design & consulting
      • Recruitment services
      • Lease an expert
    • About
      • How we work
      • NBConsult Group
      • Partners
      • Lightbox Digital
    • Blog
    • Join us
    • Contact

    • Home
    • Services
      • Application & software development
      • Outsourced software development
      • Project based resourcing
      • Digital marketing & consulting
      • Graphic design & consulting
      • UI / UX design & consulting
      • Recruitment services
      • Lease an expert
    • About
      • How we work
      • NBConsult Group
      • Partners
      • Lightbox Digital
    • Blog
    • Join us
    • Contact
    misconceptions about software development
    Misconceptions About Software Development
    Sep 26, 2022
    julia programming langugae
    Julia Programming Language
    Nov 7, 2022

    Shrinking Logs and Defragmentation In SQL Server

    shrinking logs and defragmentation in sql server
    shrinking logs and defragmentation in sql server

    Shrinking logs in your SQL Server is a great way of recovering storage space in your database and can sometimes be a better alternative than simply acquiring more storage space instead of optimizing what you already have. Shrinking your logs recovers space in your database by moving data from the end of a file to the unoccupied spaces at the front of the file and thus utilizing that otherwise 'dead' or wasted space. This will create unallocated space that can be returned to the file system for later use.

    This process can be done by right clicking on your database, Tasks -> Shrink -> Files. select the type as log and select to 'Reorganize pages before releasing unused space'. This is a fairly quick and effective method of better utilizing the storage space you already have.

    What is fragmentation and why does it occur in your database? As data is modified in your database, its indexes will become increasingly fragmented, thus making ordered data retrieval less efficient and reduce overall database performance. For small scale databases this isn't too much of an issue but for larger databases or even data warehouses, this is a serious concern where to acquisition of data quickly is of paramount importance.

    There are a number of different forms of fragmentation such as:

    File fragmentation at the operating system level - Deletes and inserts cause the page to become fragmented as the physical sequence of data pages no longer matches the logical order.

    Logical order fragmentation - Similar to file fragmentation and caused by deletes and inserts, the index causes pages to be out of order.

    Page density fragmentation - Also known as internal fragmentation, will occur as pages split to make room for information added to the page. This will in turn create new pages that may have free spaces on it. These free spaces make SQL Server think that the data is taking up more space that it actually is.

    There are a number of ways of dealing with and correcting defragmentation such as using SQL Defrag Manager or by running specialized queries to locate the most fragmented tables and the defrag them.

      Contact us


      Related posts:

      laravel envoyer and forgeProvisioning A New Digital Ocean Server With Laravel Forge, And Deploying Code With Laravel Envoyer easily view your laravel logs using laravel log viewerEasily View Your Laravel Logs Using Laravel Log Viewer implementing laravel echoImplementing Laravel Echo And Socket.io With A Laravel API And Ionic Vue App dynamic doughnut graph using laravel vue componentDynamic Doughnut Graph Using Laravel Vue Component
      Share
      0
      Alex Farrell
      Alex Farrell
      Software Developer and still learning something new everyday. Got into software development only a couple years ago so still relatively new to the game but loving every second of it. Bit of a nerd with 2 spoilt dogs.

      Leave a Reply Cancel reply

      Your email address will not be published. Required fields are marked *

      Lava Lamp Lab


      Like technology, a lava lamp constantly changes form, producing new conditions with every passing moment



      lava lamp lab facebook   lava lamp lab twitter   lava lamp lab linkedin   lava lamp lab instgram

      Services


      Application & software development

      Outsourced software development

      Project based resourcing

      Digital marketing & consulting

      Graphic design & consulting

      UI / UX design & consulting

      Contact Us


      +27(0) 83 419 4851

      +27(0) 21 036 1165


      switchon@lavalamp.biz


      Unit 1 Monaco Square,
      14 Church Street,
      Durbanville,
      Cape Town, 7550

      NBConsult Group


      nbconsult
      nbconnect msp
      nbclearning
      river broadband
      designer needed
      © 2023 Lava Lamp Lab (Pty) Ltd | All Rights Reserved | Privacy Policy
      Contact us now

        Application & software development

          Outsourced software development

            Project based resourcing

              Digital marketing & consulting

                Graphic design & consulting

                  UI/UX design & consulting

                    Lease an expert

                      Recruitment services

                        We are using cookies to give you the best experience on our website.

                        You can find out more about which cookies we are using or switch them off in settings.

                        Lava Lamp Lab
                        Powered by  GDPR Cookie Compliance
                        Privacy Overview

                        This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.

                        Strictly Necessary Cookies

                        Strictly Necessary Cookie should be enabled at all times so that we can save your preferences for cookie settings.

                        If you disable this cookie, we will not be able to save your preferences. This means that every time you visit this website you will need to enable or disable cookies again.

                        3rd Party Cookies

                        This website uses Google Analytics to collect anonymous information such as the number of visitors to the site, and the most popular pages.

                        Keeping this cookie enabled helps us to improve our website.

                        Please enable Strictly Necessary Cookies first so that we can save your preferences!

                        Cookie Policy

                        More information about our Cookie Policy