SQL Server 2005 Tidbit 035

Data Storage?

Credit for this one goes to Chris Avis, who had this asked of him in an event recently…

“What is the max number of filegroups supported as part of a single database?”

Well… it’s a nice big binary number: 111111111111111 (or 32,767 for you decimal lovers). 

The answer is found here.

Got an IT question?  Give me a comment, or contact me.