The fundamentals of database structure

RIL_button( “http://sqlconcept.com/2011/04/22/the-fundamentals-of-database-structure/”, “The fundamentals of database structure” );
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

Continue reading [...] The fundamentals of database structure [...]

Work on itWell, now...OKGoodGood job! (1 votes, average: 5.00 out of 5)

If you gave a rating less than the maximum, you must leave a comment with suggestions on how to improve the post. :)

Loading ... Loading ...

 

Data waterfalls and data avalanches

RIL_button( “http://sqlconcept.com/2011/04/20/data-waterfalls-and-data-avalanches/”, “Data waterfalls and data avalanches” );

The concept was introduced some time back and one of its enablers has always been the price of storage.

Even in the 80′s, the data waterfalls and data avalanches were quite predictable, however, the constantly improving storage technology shifted the focus away from the problem. Not much has changed

Continue reading [...] Data waterfalls and data avalanches [...]

Work on itWell, now...OKGoodGood job! (No Ratings Yet)

If you give a rating less than the maximum, you must leave a comment with suggestions on how to improve the post. :)

Loading ... Loading ...

 

Treat your data as you would like to be treated

RIL_button( “http://sqlconcept.com/2011/04/18/treat-your-data-as-you-would-like-to-be-treated/”, “Treat your data as you would like to be treated” );

 

The concept of data storage is as old as the world: the folklore and the storytelling in ancient societies were in a way a kind of a ‘data storage’. The stories were rolling down in time from generation to generation.

The difference between the

Continue reading [...] Treat your data as you would like to be treated [...]

Work on itWell, now...OKGoodGood job! (No Ratings Yet)

If you give a rating less than the maximum, you must leave a comment with suggestions on how to improve the post. :)

Loading ... Loading ...