Categories
HOW TO Microsoft SQL Server Windows 10 Windows 7 Windows 8 / 8.1 Windows Server 2008 Windows Server 2012 Windows Vista Windows XP

HOW TO download SQL Server Service Packs or Windows Updates Offline Installers

Microsoft Update Catalog contains the list of Windows Updates and also the Updates of Microsoft Products that can be installed via Windows Update functionality.

Using the Search bar it is possible to filter the results to search, for example writing “SQL” you will find a list of Service Packs, Updates, Future Packs and Critical Updates for different versions of SQL Server.

Steps to download and install updates from the Windows Update Catalog

To download updates from the Windows Update Catalog, follow these steps:

  1. Click Download.
    Note If you are prompted, click Accept to accept the license agreement.
  2. Select the location where you want to save the updates. You can either type the full path of the folder, or you can click Browse to locate the folder.
  3. Click Continue to start the download.
  4. When the download is complete, click Close to close the Download Window.
  5. Close the Windows Update Catalog Window.
  6. Find the location that you specified in step 2.
  7. Double-click each update, and then follow the instructions to install the update. If the updates are intended for another computer, copy the updates to that computer, and then double-click the updates to install them.

Source: How to download updates that include drivers and hotfixes from the Windows Update Catalog

Did my HOW TO help you? Leave a reply.

Categories
Microsoft SQL Server

Script to rebuild or reorganize indexes in SQL databases

This link contains useful information and scripts to be used to rebuild or reorganize indexes in SQL databases.

Personally I found really useful the script at point D

https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-db-index-physical-stats-transact-sql?view=sql-server-2017

You can eventually comment adjust the following lines to prepare the scripts without run them

        --EXEC (@command);  
        --PRINT N'Executed: ' + @command;
        PRINT @command; 
        PRINT N'GO';

Did my post help you? Leave a reply.