If you have three minutes to spare, swing by Paul Randal’s blog and answer his survey questions about the size and distribution of your database. The results are very interesting. I was most interested in the number of respondents to each of the questions. As each size category switched, fewer and fewer people responded. However, a lot more people responded than I expected. 94 last I looked had databases under 10gb in size, but 42 had databases over 1tb. Yeah, that’s only 1/2, but, holy cow, it’s 1/2.
I wish I had a database to manage that was over 1tb. Back in the 7.0/2000 days I was at a dot com that was getting close. When I left they had 700gb. I understand they got close to 850 before the company folded. Managing that much data in SQL Server 7 and 2000 was like wrestling a very serious bear. I’d love to see what it’s like now.