meta user
network profile
| bio | website | |
|---|---|---|
| location | ||
| age | 38 | |
| visits | member for | 1 year, 10 months |
| seen | yesterday | |
| stats | profile views | 24 |
MSSQL DBA and FirebirdSQL Database Developer
|
Jun 4 |
comment |
No luck trying out Firebird 3.0 I did some systems in Firebird and they're working flawlessly for almost half decade - I know it as the person maintaining it tell me that. |
|
Mar 26 |
comment |
Data Base Administration Oracle vs MySql? MySQL = Camry? It's more to a Corolla..... |
|
Mar 26 |
comment |
Is there a reason/benefit I am not aware of for this kind setup? In MySQL I really have no idea. In MS SQL Server, one could specify exclusive row locks to be held to the end of the transaction on a table hint on the above SELECT query and no one will be able to read that record until the txn ends. |
|
Feb 8 |
comment |
Is it more secure to go through a 3rd database to connect two databases using the same login? @FabricioAraujo: the requisites defines the design, so a design must be correct before being secure. A secured incorrect design is worthless - a insecure correct design can be made secure anytime. |
|
Feb 8 |
comment |
Is it more secure to go through a 3rd database to connect two databases using the same login? @Rachel: why you don't mentioned the "multiple PrivateDB" on the question? That changes everything... ;-\ |
|
Jan 25 |
comment |
Can someone explain why select with nolock will query a potion of updated data? @SQLKiwi: Thank you, corrected. |
|
Dec 22 |
comment |
Primary Key on a View because that virtual table (select) is a intermediary result of a more complex process, so in that step of the process is easier to get the intermediate result with duplications (because have just the needed columns to exibition, and other columns would be needed to disambiguate) and finalize it on the client. |
|
Dec 20 |
comment |
Primary Key on a View what is the use of a table (virtual or otherwise) with duplicate rows? Reporting is one. You generate a resultset that have all info needed in a single (somewhat denormalised) presentation to the report tool get this job done easily. You can make that query remain on the database using a view and reports only need to include some filters to get the info needed. |
|
Dec 12 |
comment |
One Big Database vs. Several Smaller Ones Unless you put them on different instances/home... |
|
Dec 12 |
comment |
One Big Database vs. Several Smaller Ones Interesting concept, it relates to filegroups on SQLServer and tablesspaces on Oracle (if the memory doesn't fail on that last). But you won't need different databases on these two to accomplish SetupB... |
|
Nov 1 |
comment |
INT or CHAR for a Type Field Sincerely, this table will be much more useful without that unique constraint... (Second edit) |
|
Oct 31 |
comment |
INT or CHAR for a Type Field Why people like to stay deleting comment? Is pretty annoying. |
|
Oct 31 |
comment |
INT or CHAR for a Type Field Yeah, code is optional to allow represent an vehicle type that is not codified yet. |
|
Oct 20 |
comment |
Should you design the database before the application code is written? +1 This question provoked a very interesting discussion. |
|
Oct 18 |
comment |
Should you design the database before the application code is written? @dportas: not all DB changes, only RADICAL ones. Minor changes are part of the business of doing software. But having to split the data in 2 different databases in the middle of work are a failure on the design and the capturing business rules. (It actually happened to me. |
|
Oct 18 |
comment |
Should you design the database before the application code is written? @dportas: while code will change radically between an release and another, db structures change much less. Data which is relevant to the [business] process will continue to be relevant. The last project used Agile (XP), the DB was designed beforehand with great success. Changes concentrated in code (maybe 70%) and the rest in DB. |
|
Oct 17 |
comment |
Should you design the database before the application code is written? @dportas: while this is true (business rules change), a well designed db will not change radically between an iteration (or sprint, or whatever) and another, since it reflects all the relevant data structures of the work process. If this happens (radical change), means a fail on the business rules capturing activities. |
|
Oct 13 |
comment |
What are the performance considerations between using a broad PK vs a separate synthetic key and UQ? +1 for the reference Mrs Tripp excelent articles in indexing. |
|
Oct 11 |
comment |
Automated UML2 Class Diagram generation from SQL? "3. Folow this guide"... Seems that would have an link, but there's none... |
