When is it better to write "ad hoc sql" vs stored procedures
86508
What are the pros and cons to keeping SQL in Stored Procs versus Code
62267
MySQL stored procedure vs function, which would I use when?
114643
What is the difference between "AS" and "IS" in an Oracle stored procedure?
136080
What are the arguments against or for putting application logic in the database layer?
126514
Does anyone use Right Outer Joins?
34096
LEFT JOIN vs. LEFT OUTER JOIN in SQL Server
105953
When to use with clause in sql
17367
Fluent and Query Expression — Is there any benefit(s) of one over other?
100793
What's better here - a single column or multicolumn primary key?
38981
How can I prove that the following T-SQL is bad for performance?
74192
Is storing a delimited list in a database column really that bad?
109062
Should dbo schema be avoided?
54760
MySQL INSERT INTO SELECT vs BULK INSERTs performance
68967
INNER JOIN ON vs WHERE clause
18890
INSERT INTO vs SELECT INTO
110644
Are there any disadvantages to always using nvarchar(MAX)?
75971
Is there a PL/SQL pragma similar to DETERMINISTIC, but for the scope of one single SQL SELECT?