692 reputation
48
bio website
location
age
visits member for 3 years, 7 months
seen 17 hours ago

Retired. Once a programmer, then a DBA.


17h
comment How To Recover Data From A Corrupt Mdf File?
I couple of years ago, I had to do some data archaeology on these kinds of files, without SQL Server installed. I found a tool and the web that would copy a single table to a single table in csv format. I'm sorry, but I don't remember the name or the location of the tool.
17h
comment Column A or Column B required MS Access DB
If this is the case, that's where the concept of class table inheritance applies.
18h
answered Column A or Column B required MS Access DB
Sep
19
comment When to use a multidimensional relationship in an ERD?
No, I don't. The only time I needed to understand n-ary relationships was in the context of a star schema. But they can be useful feature of ER modeling with no intent to build a star schema.
Sep
18
revised When to use a multidimensional relationship in an ERD?
typo
Sep
18
answered When to use a multidimensional relationship in an ERD?
Sep
15
comment How to represent foreign key in an ER diagram?
If you will search on "ER Diagram Customers Transactions" you will get a lot of images that show various ways to do what you want.
Sep
15
answered How to represent foreign key in an ER diagram?
Sep
10
answered Completion of ERD, uncertainties about generalization/specialization and primary keys
Sep
10
comment Completion of ERD, uncertainties about generalization/specialization and primary keys
This one was migrated from SO. But there is already a duplicate of the question here.
Sep
9
answered Best way to create relationship between multiple tables
Sep
5
comment How to query for records based on most recent version
If you MUST, for some reason, represent dates as character strings, then you'd better come up with a representation that will order correctly. Something like '2004-01-03'. Otherwise, figuring out which one is the latest one will be the devil's own work.
Sep
5
comment How to query for records based on most recent version
This is a helpful answer. However, MAX([date]) is subject to the same ordering problems pointed out in other answers. If the date really represents a date, then it needs to be represented in some datatype where MAX([date]) is really the latest date. The data in the OQ will NOT order correctly.
Sep
5
comment In what way are Access tables linked with SQL server?
Pieter's answer is correct. If, in addition, you want to know how to protect the SQL Server data from the casual Access user, I suggest you look into SQL Server DBA tools for regulating access by certain users to read-only. My memory is hazy on this score, so I don't want to guess at an answer.
Aug
26
comment How to design database with january-december for every entry
You need to clarify what you are attempting. In particular, what is a "transaction"? In classic order processing systems, a transaction would have a date. You would get monthly totals by aggregating, using GROUP BY and some function that extracts the month from the date.
Aug
22
comment Does a Key-Value type table still needs a auto increment key?
Excellent, for the "auto-pilot" bit. Design principles are no substitute for thought.
Aug
20
comment Is it possible to automatically convert/load an Access database into a CSV or TXT file?
Is an interactive method an answer to your question? If not, why not? If so, have you tried going into Access and using "Table (right click), export..."?
Aug
19
comment Converted ERD into Dependency Diagram 1NF, 3NF
When I learned the ER model, it did NOT include FKs. What your professor is teaching you is to use ERDs as a depiction of a relational design. That is, in fact, the mainstream today, but it is not the classical way.
Aug
14
comment Composite Primary Key column order
Back in the day, I tended to focus on correctness, completeness, and flexibilty during initial design, and to leave tuning for speed to a later point in time. At that time, I would test for the cost penalty of alternative designs, using data obtained from "real world" production. YMMV.
Aug
12
awarded  Yearling