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 1945

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.

5
votes
You could greatly simplify this by adding a few fields to your existing tables. Add: ChangeDate - smalldatetime that indicates when a record was added Active - BIT ChangeBy - user who added the rec …
answered Feb 6 '12 by JNK
78
votes
Performance would be a BIG reason. Just because they can't change the data doesn't mean they can't affect the server. A poorly written query could bring the production environment to its knees, and …
answered Jan 6 '12 by JNK