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 ;-)

Welcome to our blog!

Welcome! Before we describe what you can get from reading our new blog, we want to introduce ourselves to anyone new to this space. BI Architects is a specialist in Business Intelligence Solutions and is located in the Netherlands. Our mission is to offer customized Business Intelligence and System Integration, through honest advice and implementation projects where quality, commitment, up to date knowledge and understanding in and optimizing of the processes of our customers stands central.

What can you find at the BI Architects blog? Our blogging team will cover a wide-range of Business Intelligence topics, including Dimensional Modeling, System Integration, Project Management, News, Information on trends, and more. Check back on a regular basis to read about:

• Project Management approaches in Business Intelligence projects
• Business Intelligence with online Project Management software from Clarizen
• Business Intelligence in Trading & Risk Management with Commodity XL (CXL) from Triple Point
• Sharepoint 2010 dashboard solutions
• Innovations in Business Intelligence software

Our blogging team will also describe practical solutions for challenges we have with tools like:

• Microsoft Visual Studio
• SQL Server
• SQL Server Integration Services (SSIS)
• SQL Server Analysis Services (SSAS)
• SQL Server Reporting Services (SSRS)
• Sharepoint 2010
• etc.

So, enjoy reading, and don’t forget to comment. We want to hear from you.

The BI Architects Blogging Team