This is a guest post by Christoph Hanser. Christoph is currently working as a freelancer in .NET, SQL Server, and BizTalk projects. He is originally from Hamburg but has studied also for a semester in Sweden at the Uppsala University. His blog is http://eai-technologies-and-their-pitfalls.blogspot.com/.
What does a fancy Louis Vuitton and an armee bag have in
Continue reading […] Using Louis Vuitton and an Army bag to store your historical Data […]
Sorry about the blunt title, but I had no choice.
In a previous post I mentioned how important the design of the database files is. It is important for two reasons: performance and recovery.
Here comes the analogy:
Imagine, you are writing a book. You have written already 500 pages and you are keeping indigo copies somewhere.
Continue reading […] How to risk losing data and how to have most down time […]
Think of a database as a bucket. Actually, scratch that.
Think of the database as a chemistry distillation glassware. Something like this:
Database File Structure
Each database is structured in a way that it has at least one filegroup (containing at least one data file), and at least one log file.
Think of the filegroups as
Continue reading […] The fundamentals of database structure […]