Home / server / Questions / 52950
Accepted
AJ.
Asked: 2009-08-12 13:08:39 +0800 CST

Pointers on managing database with 4000 tables?

  • 772

I'm in the middle of designing a software system storing data in about 4000 tables in Microsoft SQL Server 2008. Does anyone have any pointers to ease management of such a large number of tables?

Thanks!

P.S.: It's already normalized.

sql-server sql-server-2008 sql

2 Answers

  1. About the only suggestion I can offer is learn to love the filter icon in SSMS to make it easier to find the objects you are looking for.

    • 3
  2. Best Answer

    Use declarative Policy-Based Management instead of managing individual tables.

    • 0