Home
  1. Improving System Performance
  2. SQL Server maintenance
  3. Unneeded data

Unneeded data

Unneeded data in tables with a large number of records can increase query time and slow certain processes. Mongoose provides utilities for reducing unneeded data. SQL Server system stored procedures aid in understanding table size.
Note: This topic applies to only on-premises environments.
Related topics
  • Improving System Performance
  • Purging or compressing unneeded data
  • Examining table size
  • SQL Server maintenance
  • Improving System Performance
    • Hardware
    • SQL Server settings
    • SQL Server maintenance
      • Statistical information
      • Updating statistics
      • Fragmentation information
      • Defragmenting indexes
      • Unneeded data
        • Purging or compressing unneeded data
        • Examining table size
        • Filtering inactive records in data integration
    • Centralized Vendor Metadata Database (CVMD)
    • Customizations
    • User actions
    • Replication
    • Locking and blocking
    • Windows tools
    • SQL Server stored procedures and commands
    • Printing barcode reports in PDF format
    • Troubleshooting timeout errors