For a guy battling all the day with strange requirements (trying to fix with strange solutions ;)) may not find time to understand the platform to the deepest. Understanding the SQL Server Inside face is like looking at the GOD in real!!!
So I want to share this information on web and thought of creating a blog for the same. We may be aware of few but not all, today I took some time to publish all this in a single post.
- The technical limit for one SQL Server Instance is 32,767 databases. (Literally that count would never be reached).
- A SQL Server database which comprises of different types of objects like tables, views, Monster stored procedures etc., has a technical limit of (2 Power 31) - 1 (just more than 2 million objects). I never saw a database more than tens of thousands objects in all those several projects worked in various domains.
- The size, from 2MB to 524,272 Terabytes (This figure is no where close to the present business database sizes, and by the time they grow, SQL Server will grow too ;)).
- The SQL Server database, which is enough intelligent to shrink itself automatically or manually, has its own set of system tables to hold the database catalog.
If I have to talk something SQL Server database is NOT:
It is NOT synonymous with an entire SQL Server Instance. Its neither a single SQL Server table nor a specific operating system file.
