network profile
| bio | website | porqueafoto.blogspot.com |
|---|---|---|
| location | Sao Paulo, Brazil | |
| age | 41 | |
| visits | member for | 1 year, 10 months |
| seen | Feb 2 at 6:42 | |
| stats | profile views | 12 |
|
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 25 |
answered | Slow queries on SQL Server |
|
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. |
|
Sep 26 |
answered | Survey database design: associate an answer to a user |
|
Sep 26 |
awarded | Supporter |
|
Sep 26 |
answered | Survey database design: first version. Are there errors? |
|
Sep 26 |
answered | Design Pattern - One of Many Parent Tables |
|
Aug 23 |
awarded | Teacher |
|
Aug 23 |
awarded | Editor |
|
Aug 23 |
revised |
Updating Multiple Rows with Data from Column A into Column B? Grammatical and spelling correction, plus assumption on *_dt columns type |
|
Aug 23 |
answered | Updating Multiple Rows with Data from Column A into Column B? |
