I’m pretty much a beginner at working with SQL Server databases.
I know just enough SQL to get myself in trouble.
So I’ve hired a consultant who has been very helpful in creating some JAVA apps between my raw sources and my database.
The apps are pretty slick and I’m happy with them. The consultant also created a number of tables. Some of these tables hold tens of millions of records in them.
That’s where I get concerned. Not about the table length but the possible size of the tables.
The consultant has added four fields to each table - a created by, created when, modified by, modified when field. Two of those fields are Varchar and can each have as many as 40 characters. The other two fields are date/time so I’m less concerned about them.
My question is - how much size is being added to my database by these character fields repeated millions of times?
Any DBA’s who have an opinion please sound off.
The database is an analytical DB, not transactional. Does the inclusion of modify elements make any sense?