Skip to content
Born SQL

Primary Menu

  • Home
    • About
    • Contact Us
  • Hire me!
    • SQL Server Performance and Health Check (dbSnitch)
    • Upgrade Wizard
    • Disaster Recovery
    • 2-Day Tune-Up
    • DBA
    • Speaking
  • Resources
    • SQL 2000: Duplicate Index Finder
    • Database Backup Sync and Restore
    • Max Server Memory Matrix
    • SQL to Excel Exporter tool
    • Blog series links
  • Blog
  • IT documentation

Tag: Disable

Disable, don’t delete those indexes

Posted on 20 December 201718 December 2017 by randolph

A quick post this week, since it’s that time of the year when people do gift exchanges and put up colourful lights. Here goes: If we need to remove an unused index, we should disable it, not delete it. In SQL Server Management Studio, we can do this in the Object Explorer by right-clicking on
-> Continue reading Disable, don’t delete those indexes

Tagged Disable, Indexes, Maintenance 2 Comments

Posts navigation

Randolph West

Randolph West

Randolph West (they/them) is a Microsoft Data Platform MVP, and has worked with SQL Server since the late 1990s. When not consulting, you can see them acting on the stage and screen, or doing voices for independent video games. Also available for mentoring, talks on SQL Server and technology in general, Randolph offers training for junior DBAs. Connect with Randolph on Twitter. Buy their books on Amazon.

View Full Profile →

Recent Posts

  • T-SQL Tuesday Retrospective #009: Beach Time
  • It’s 2021, so why are you reading this?
  • A blog post about writing blog posts
  • Security update for all supported versions of SQL Server (CVE-2021-1636)
  • T-SQL Tuesday Retrospective #008: Gettin’ Schooled
  • 2020 was certainly a year on the calendar
  • Goodbye PASS
  • Announcing the Calgary Data User Group
  • T-SQL Tuesday Retrospective #007: Summertime in the SQL
  • T-SQL Tuesday Retrospective #006: What about blob?

Follow @BornSQL on Twitter

Follow @_randolph_west on Twitter

Randolph West

Archives

Popular Tags

Azure Azure SQL Database Backup Backups Beginner Careers Cloud Community Compatibility Configuration Corruption Data Recovery data types date datetime datetime2 Development DevOps Disaster Recovery Fundamentals Internals Linux Maintenance Max Server Memory Migration PASS Summit Performance Recovery Security SQLNewBlogger SQL PASS SQLSaturday SQL Server SQL Server 2000 SQL Server 2016 SQL Server 2017 SQL Server 2019 SQL Server on Linux Storage Engine T-SQL T-SQL Tuesday Temporal Tables time tsql2sday Upgrade
Calgary, Canada
info@bornsql.ca
+1-587-997-4845
  • Twitter link
  • Linkedin link

Copyright © Born SQL, a 1690406 Alberta Ltd company

This site uses cookies: Find out more.