SQL UDF and query optimization
64636
udf vs direct sql performance
11985
A beginner's guide to SQL database design
41314
Is there a REAL performance difference between INT and VARCHAR primary keys?
53417
Calculate execution time of a SQL query?
96731
SQL Server: Query fast, but slow from procedure
33417
Tune a simple inner join query
84727
PDO support for multiple queries (PDO_MYSQL, PDO_MYSQLND)
140337
Using an aggregate function in where
77930
Which is better: Ad hoc queries or stored procedures?
37566
How to create a SQL Server function to "join" multiple rows from a subquery into a single delimited field?
60039
Super poor UDF performance on only 1 server, not identical other server
20992
SQL not engaging parallelism for extremely large query
143698
Why my sql query run faster than my stored procedure?
139728
Query speed based on order of columns
151604
Why does a query run slower in a Stored Procedure than in the Query window?
75971
Is there a PL/SQL pragma similar to DETERMINISTIC, but for the scope of one single SQL SELECT?
18781
SQL count(*) performance