Stored Procedure with HINT "WITH RECOMPILE" loses performance, solved with DBCC FLUSHPROCINDB
103235
When a previously-fast SQL query starts running slow, where do I look to find the source of the issue?
87630
Oracle equivalent of ROWLOCK, UPDLOCK, READPAST query hints
85835
Slow Trigger performance when big batches
75609
Procedure Cache Dropping
141091
How can sanitation that escapes single quotes be defeated by SQL injection in SQL Server?
138057
CAST throwing error when run in stored procedure but not when run as raw query
97691
JDBC batch insert performance
79009
Workaround for LINQ to SQL Entity Identity Caching and Compiled Query Bug?
24417
"INSERT IGNORE" vs "INSERT ... ON DUPLICATE KEY UPDATE"
111753
UPDATE performance where no data changes
78656
Why would recompile query hint result in different plan for same adhoc statement after freeproccache?
64636
udf vs direct sql performance
10642
SQL Server - what isolation level for non-blocking select statements?
148387
Synchronized stored procedure execution in mysql
132935
Does LINQ's ExecuteCommand provide protection from SQL injection attacks?
86508
What are the pros and cons to keeping SQL in Stored Procs versus Code
50702
Run stored procedures in parallel