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
1
vote
Most applications need to have some way to provide integration. Ideally, you would have a full API, a web service or at least make some database objects containing business logic available. Everyone i …
answered Sep 22 '10 by JeffO
8
votes
There are plenty of instances where SQLite is plenty. The user, department, or company rarely outgrow it (We don't hear about it as much because no one calls a programmer if the application is working …
answered Jul 28 '11 by JeffO
1
vote
IMHO a single table shouldn't be a problem, so don't create an issue where one doesn't exist - yet. There is a lot you can do to help performance. You can partition a single table to multiple files ba …
answered Dec 28 '10 by JeffO
2
votes
Why not? Because you want to eliminate a column? Just because the requirements call for three columns to be unique, doesn't mean it has to be the primary key. You may think that rule will last forev …
answered Sep 29 '10 by JeffO
5
votes
You have to decide what's the bigger issuer, finding the procs you're looking for or quickly deciphering their meaning? If you see: memberGetID memberGetName memberGetThis memberListSomething membe …
answered Jan 26 '11 by JeffO
0
votes
SQL Server 2008 FILESTREAM option for a VARBINARY(MAX) column is the best of both worlds. The images are still saved to a file to help with performance, but your code will just save to a table and the …
answered Jun 14 '12 by JeffO
1
vote
I don't know enough about your application to know when this amount of data break down makes sense. If you require strong control over city-state-country-zip code combinations (voter registration, eme …
answered Aug 29 '11 by JeffO
1
vote
What you're considering by having an unfriend field (I prefer the idea of it being a date) which is like a soft delete. It would allow you to maintain other tables that rely on the ID of this relation …
answered Apr 8 '13 by JeffO
0
votes
Start with the frontend, but first, why can't they find an application that already exists? This would give some more insight on this project. Do they have some unique requirements or do they think yo …
answered Mar 8 '11 by JeffO