network profile
| bio | website | |
|---|---|---|
| location | ||
| age | ||
| visits | member for | 1 year, 2 months |
| seen | Apr 23 at 15:01 | |
| stats | profile views | 30 |
|
Mar 6 |
awarded | Yearling |
|
Feb 8 |
accepted | Looking for industry standard and/or tool to represent and export RDBMS metadata |
|
Feb 6 |
comment |
Looking for industry standard and/or tool to represent and export RDBMS metadata Thank you for your feedback. This is very close to what I wanted. |
|
Feb 6 |
comment |
Looking for industry standard and/or tool to represent and export RDBMS metadata Thank you for your feedback. I was looking for something more generic. Each vendor may have different format for reporting the results. I was looking for a generic format that would work across different vendors. |
|
Feb 6 |
comment |
Looking for industry standard and/or tool to represent and export RDBMS metadata @Phil, thanks for your input. If you care, you can make your comment an answer and I will up-vote it. |
|
Feb 6 |
asked | Looking for industry standard and/or tool to represent and export RDBMS metadata |
|
Sep 25 |
comment |
Schema for an RBAC (Role-based Access Control System) How do you define a module? Where is the "operation" equivalent in BARC? |
|
Sep 22 |
comment |
Product Attribute List Design Pattern What do you mean by "Authorized list of attributes"? |
|
Sep 17 |
comment |
How do I optimize this database design? Could you provide an English description of the tables and what the link represents? |
|
Sep 16 |
comment |
Does 'Cities' deserve a separate table? @NeilMcGuigan, City and state columns that you see in Customer represent 1 foreign key of the parent table (called city) in this diagram. This is not the only way to do this as mentioned elsewhere in this post. |
|
Sep 14 |
comment |
Curious Database building Problem (ER Diagram) It is not valid to remove the "Autoshop" as it represents the point of sale. Also for @JacobRich, please include what you already have in the body of your question. The association "Autoshop" has "Customer" may not be valid because a customer can visit any branch of the company (unless branches don't share customer data or branches are geographically located in such a way that makes sharing customer data meaningless). Also, a supplier may supply 1 or more "Stock Items" and a "Stock Item" may be supplied by 0,1 or more suppliers., It depends on your business rules. |
|
Sep 12 |
answered | An “unlimited” data model |
|
Sep 10 |
answered | Designing an Accumulating Snapshot with Repeated Groups, need advise |
|
Sep 10 |
answered | Updating data from a report: any potential pitfalls? |
|
Sep 7 |
comment |
Why is a Star Schema more normalized than a 3NF Schema? "3NF is the most normalized among common schema models", this is not true as there are more normal forms than 3. |
|
Sep 6 |
revised |
COUNT and SUM at the same time after removing duplicate rows Changed title to reflect requirement |
|
Sep 6 |
suggested | suggested edit on COUNT and SUM at the same time after removing duplicate rows |
|
Sep 6 |
comment |
How to Optimise Query +1, good work.Thanks. |
|
Sep 6 |
comment |
How to Optimise Query The inner join logic is fine, however, it can be written using the old style WHERE condition to avoid the "OR" operator and hence improve the possibility for utilizing the indexes. See section "Rewriting query with OR conditions as a UNION" here: componentace.com/help/absdb_manual/increasesqlperformance.htm |
|
Sep 5 |
comment |
How to Optimise Query In your query: "select * from Dispatch d inner join DispatchLink dl on d.DispatchId = dl.DispatchLink1 and d.ContractId = dl.ContractLink1 or d.DispatchId = dl.DispatchLink2 and d.ContractId = dl.ContractLink2" try to remove the "OR" condition and replace it by UNION of 2 SELECT statements each using no "OR", also use the only key columns in both SELECTs instead of the "*", just to make the test as pure as possible. |
