Query to find the size of the database and database file

Technique 1:


     EXEC sp_helpdb

Technique 2: For a specific database:

sp_helpdb'adventureworks'

And you get the following output: (this one gives you the database and data file information for a specific database)




Technique 3: be in the context of the database and run sp_spaceusedGives you the database size and certain more properties of it:


     EXEC sp_spaceused

This is what you get:

Technique 4: use sys.master_files


SELECTDB_NAME(database_id)AS DatabaseName,
Name AS LogicalName,
size*8/1024 Size_in_MB,
max_size
FROM sys.master_files
WHEREDB_NAME(database_id)='AdventureWorks'
GO




If you liked this post, do like us on FaceBook at http://www.facebook.com/pages/BI-Architects/249973345047634?sk=wall

Kimball Design Tip #139 Much Ado About Nothing

Yesterday I've read Design Tip #139 from the Kimball Group. In this tip Margy Ross is talking about renewed rumblings in the DW/BI industry about the Kimball versus Inmon approaches. She refers to a white paper, written in January 2008 by the Kimball Group, entitled “Facts and Fables about Dimensional Modeling”. In this white paper, the Kimball Group tries to tackle misunderstandings about dimensional modeling that appear in DW/BI industry publications, training, and marketing materials.

Margy Ross also refers to an article she wrote almost eight years ago for Intelligent Enterprise magazine (since absorbed into InformationWeek) entitled “Differences of Opinion”. At the time, she tried to fairly contrast the Kimball bus architecture approach versus the Corporate Information Factory. She had several clients who were struggling to make a decision between the two dominant schools of thought, so she attempted to summarize the similarities and differences.

If you're are interested in this and other Kimball Design Tips you can read them over here. They are worth reading ;-)