Tag Info

Hot answers tagged

6

In SQL Server, you can create file groups that consist of 1 or more files. You can then migrate data into those file groups individually by rebuilding the clustered index for each table on that file group. You can also do the same for indexes by rebuilding the index by specifying the desired file group. You can use file size caps to ensure the files do ...


5

If you can trust the IDENTITY column to be ever-increasing, I see no reason to store this information. It becomes redundant because it's information you can obtain from data already stored in the table (as you have already shown). Storing it is wasteful in terms of: additional disk space additional memory, since the data will hopefully be in memory most of ...


3

The validity depends on how users want to look at the data. You are looking at it as just a transaction fact. Other types of fact tables include periodic snapshots and accumulating snapshots. If you want to see all the times that someone corrected a row to help decrease erroneous entries, the effective dates may be appropriate so it's clear that the ...


2

On a storage system that offers RAID data protection, I highly recommend splitting the database into several equally sized data files with one file on each LUN/drive/mount point. That gives increased aggregate service queue depth to reach the data at both the logical & physical drive levels. Without RAID protection provided by the underlying storage, ...


1

This seems nearly identical to the following question, and my answer there should be detailed enough to explain the concept (and is just too much to copy and paste here). Don't know how to transform variable entity into relational table For your case specifically I would think it should work itself out to be something along the lines of: Publication ...


1

May I suggest that you take a look at the treasure trove of Open Source software that is out there in this area. A Google of "open source double entry accounting software" gives several promising avenues of investigation. You could look at the GNU accounting package here, a couple of review sites (1 & 2) and finally the wiki of accounting software with ...


1

A Journal is a chronological listing of all transactions of a specified type for an accounting system. Here is a classical presentation on ledger paper of a simple Sales (on Account) Journal: Note that every line is a single transaction, with Total Debits = Total Credits; and that every transaction hits the same three accounts. A Cash Sales Journal would ...



Only top voted, non community-wiki answers of a minimum length are eligible