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 answers only user 555

Best practices are generally and informally recognized as the methods and processes that have been shown over time to be superior to those achieved by other means.

6
votes
Please don't combine the various _type tables. Your future self (and anyone that ends up writing queries against the tables) will thank you. If you combine the tables, you give up the ability to ha …
answered Apr 16 '12 by Justin Cave
50
votes
I would tend to be very suspicious of any set of universal best practices because, for most of these fields, the devil is in the details. Just because the information is relatively common doesn't mea …
answered Jul 11 '11 by Justin Cave
5
votes
There is no need to grant the CONNECT role. In 10.2, Oracle finally reduced the set of privileges assigned to that role to just CREATE SESSION but in previous versions, that role has many more privil …
answered Feb 12 '12 by Justin Cave
3
votes
The standard approach in Oracle is that global temporary tables are first-level objects. They should be created at install time when you create all your permanent tables. Doing DDL at runtime is ver …
answered Jan 14 '15 by Justin Cave
2
votes
Assuming that you allow multiple users in your application, max()+1 will guarantee that you will get duplicate values. Therefore, it is a bad practice. It's also less efficient but that is a lesser …
answered Dec 7 '15 by Justin Cave
4
votes
I certainly wouldn't want to include the server name in the TNS alias. It would seem highly probably that this would change over time as databases move from one server to another and as organizations …
answered Aug 5 '14 by Justin Cave