411 reputation
25
bio website porqueafoto.blogspot.com
location Sao Paulo, Brazil
age 42
visits member for 3 years, 5 months
seen Dec 9 at 21:20

Apr
23
comment MySQL schema for recurring events - Query by specific date
Please, don't forget to share with us your 'slight modification'. Have a nice work.
Apr
20
comment How can one improve the performance of a query that selects on a low cardinality column in MySQL?
It does not make much sense defining an index to a VERY low cardinality column as in your example - just three possible values. Indexes serve to narrow queriable data. But, I bet your queries rely on other columns, don't they? Can you enrich your problem, with the actual schema and query samples?
Oct
24
comment How to translate high level entity relationship into schema
Hm... my bad. Actually I'd better issue 'Authentication', not 'Authenticating'. Rounded rectangles here have no information value. They came rounded just because. I will review my post as soon as I get home.
Oct
4
comment Probable circular dependency, but query still runs
You're welcome. Accueil to the wonderful world of modeling and administering databases.
Oct
4
comment Probable circular dependency, but query still runs
One more thing. My models always consider end_date = 2100/jan/01 as from now on. This provide simpler, more straightforward, queries: ... WHERE TODAY BETWEEN start_date AND end_date. The natural way of setting end_date = NULL leads to ... WHERE start_date <= TODAY AND (end_date >= TODAY OR end_date IS NULL). Of course, for input controls at the user interfaces, the code has to interpret 2100/jan/01 as blank, and vice-versa.
Oct
4
comment SQL Server Analysis Studio naive Bayes attribute has too many states
Could you provide us a snapshot displaying part of the model as shown at the SSAS' Naive Bayes viewer?
Jan
13
comment Design Pattern - One of Many Parent Tables
The DRI acronym got me. For you all, it stands for Declarative Referential Integrity, the technique behind referential data integrity which is commonly implemented as... (drum roll)... DDL FOREIGN KEY statements. More on en.wikipedia.org/wiki/Declarative_Referential_Integrity and msdn.microsoft.com/en-us/library/…
Jan
13
comment Design Pattern - One of Many Parent Tables
Reviewing this, I began to doubt the correctness of my solution... anyway, it's been voted up twice, which I thank. Although I believe my design is valid but not suitable for the problem given, as the 'n' unions/joins are not addressed...
Nov
1
comment Slow queries on SQL Server
henderaunal, have the performance problems been solved? Please, share with us the root causes and the solution adopted.
Oct
1
comment SQL Server column level security
I offer an alternative view: it may be possible to design a DDL trigger upon the table which propagates any grant/revoke to the views based on it. Those views would be found by inspecting the objects metadata. I'll elaborate and, hopefully, write a complete solution.