Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Favorites infavorites:mine
infavorites:1234
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with Search options user 855

A relational database is a digital database based on the relational model of data. This model organizes data into one or more tables (or "relations") of columns and rows

0
votes
Why would you be making this decision? Either the client wants/needs the ability to: Assign multiple employers to each client. Have consistent data on an employer (i.e. change phone number in one pl …
answered May 31 '12 by JeffO
0
votes
You may want to consider entity relationships. You'll have flexibility (assuming that's the whole purpose), but performance is going to suffer because of it. I think this requirement is more of a li …
answered Feb 2 '17 by JeffO
2
votes
You can keep the fields common to all locations in that table, but have multiple tables handling different location types. You could add a third location-type table like GeoSpacialAddress which would …
answered Nov 22 '13 by JeffO
3
votes
If the values are coming into the database as integers, store them that way. There's no need to put the over-head of converting to strings while writing to the database. You can always relate to a loo …
answered Jan 9 '13 by JeffO
0
votes
Focus on the more complex piece first. I think it is tracking what is going on during a trip. Instead of only saving the current status, I would have a table that is more of a log. It should tell you, …
answered Dec 11 '16 by JeffO
0
votes
It seems like your Business Adviser is a position (Could be a territory.) that has one person assigned to it at a time. There would be another table that manages those assignments, so different people …
answered Apr 18 '18 by JeffO
3
votes
There are external constraints that drive technology decisions. There's just few situations where you have the need and or luxury of using database field constraints on a regular basis. Enterprises …
answered Nov 30 '16 by JeffO
0
votes
I think it is a good idea to take query performance into consideration early in the design phase, but at some point, your database has to hold the data required by your application. Even if your table …
answered Sep 2 '14 by JeffO
1
vote
If you take the "I use surrogate keys all the time" approach, you get to bypass this type of concern. That may not be a good thing because it's important to give your data some thought, but it certain …
answered Jul 11 '13 by JeffO
1
vote
With NoSQL/Document databases, you have to think about how you're going to be querying your data. Think of it like building indexes except the indexes are your data. You can have multiple indexes that …
answered Apr 29 '16 by JeffO
2
votes
Relational Databases are optimized to search for any value in the datarow effectively. Don't confuse the ability to search on "any" value in a row with "every" value in a row. The most effectiv …
answered Jan 11 '16 by JeffO