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

MySQL is an open-source, relational database management system.

2
votes
It appears you have your complaints in order. I would come up with more, but I don't think you've identified why they chose this solution. There are many benefits to normalizing and denormalizing a d …
answered Aug 27 '13 by JeffO
2
votes
If you want to make sure there is an established list of services (a table to inner join) then you need to manage the changing of this table without breaking your joins for historical records. Use a …
answered Jan 22 '15 by JeffO
5
votes
This solution uses a separate auditing table. It has pros and cons. You may prefer to eliminate the old records from your main table. Performance improvement may be negligible. Add the following fie …
answered Feb 28 '12 by JeffO
1
vote
You mentioned one: area of expertise. Maybe the structure of the database isn't too intensive, so you decide to offload some of the logic development to a team member that is more database centric. Ma …
answered Nov 16 '10 by JeffO
2
votes
Your application can connect to the database just as easily, but you may be missing out on some of the Visual Studio integrations for SQL Server (SQL Server Projects). If you don't care or aren't too …
answered Aug 11 '11 by JeffO
3
votes
is that's not your problem since you're still maintaining the code in the MySQL language. There are probably a lot of calculations in your stored procedure and other logic that you would like to …
answered Mar 31 '14 by JeffO
0
votes
Does each type have different fields or does the one field hold a different meaning depending on the ingredient category? You can have a text field to hold the extra information (sorry, I don't have a …
answered Aug 23 '11 by JeffO
0
votes
When you go against someone's current technology, they'll find any excuse to justify what they're doing. The example you gave is a team that is now making excuses and licking their wounds over the fai …
answered Mar 23 '11 by JeffO
7
votes
You should always ask yourself if a particular application needs an RDBMS. Too many applications are built with a design process that automatically assumes all the required tools and frameworks at the …
answered Mar 14 '13 by JeffO
1
vote
Instead of relying on a Updated Date/Time field, use a Version Number field. When created, it's 1 and then incremented with each update. Not hard to do at all at the database level. The monitoring ap …
answered Feb 29 '16 by JeffO
0
votes
If you want flexibility and some ease in managing the data, you'll create a separate table and link them, but if you have minimal requirements and performance is a concern, you can put them all into o …
answered Apr 13 '16 by JeffO
11
votes
Research on SQL Server 2005 and the NTFS file system (Microsoft) to compare CRUD performance: To BLOB or not to BLOB. This study was also done in a web application. You listed another database (MySQL
answered Sep 1 '11 by JeffO
3
votes
It's very difficult to switch database brands and utilize the same stored procedures. Your team either doesn't have a DBA and no one else wants to have anything to do with sql. This is nothing more …
answered Apr 7 '11 by JeffO
6
votes
The way the question is worded, you're asking for a list of things. I'm going to risk not directly answering your question, but answering when you should use an alternate solution. I can think of …
answered Jan 29 '14 by JeffO