19,083 reputation
456107
bio website sqlperformance.com/author/…
location New Zealand
age 45
visits member for 3 years, 5 months
seen 1 hour ago

May
25
reviewed Leave Open Fetch all parents from child id
May
24
reviewed Close Preventing unique key constraint violation when pre-existing row has 'expired'
May
24
reviewed Reviewed DB2 Query Error SQL0204N Even With The Schema Defined
May
23
reviewed Leave Open How to improve this query performance by indexing properly?
May
23
reviewed Leave Open Deadlock on Delete Statement
May
23
reviewed No Action Needed COPY TO .csv and add quotes to header in PostgreSQL
May
23
comment How do mySQL and web-interface deal with hashed data
The question is on-topic here, though it probably would be on Information Security Stack Exchange as well. If you don't get a good answer here within a reasonable time, consider moving it there.
May
23
reviewed Reviewed How do mySQL and web-interface deal with hashed data
May
23
comment Sort Warnings, finding out the query behind them
"Quite likely". Honestly it's hard to know :) But it is a good place to look, especially if the size of the data being sorted is large.
May
23
reviewed Reviewed Significant difference between duration for querys in SHOW PROFILE and SHOW PROFILES?
May
23
reviewed Edit suggested edit on Drawbacks of storing files in a database
May
23
revised Drawbacks of storing files in a database
added 50 characters in body; edited tags; edited title
May
23
comment Sort Warnings, finding out the query behind them
It's possible, but there are all sorts (ha!) of other reasons your query might identify a procedure. It's hard to trace sort warnings back to the source statement after the event, much better to collect information as they occur. If you think it is daft the default trace contains Sort Warnings with no T-SQL source, you're not alone.
May
23
comment Sort Warnings, finding out the query behind them
Cached plans are always pre-execution (estimated) plans. Sort warnings are only present in post-execution (actual) plans. Collecting data using Extended Events or Event Notifications is indeed the way to go.
May
23
reviewed No Action Needed Is there a way to define macros/alias in psql?
May
23
reviewed Reviewed How can I import a database dump (.sql) using pgAdmin without the PSQL Console plugin?
May
23
reviewed Reviewed Imported database file size different with original database file
May
23
reviewed Leave Open Using ODBC Connection to Access Firebird Database
May
23
reviewed Reject suggested edit on In Oracle how do you move a Schema to a different Tablespace?
May
22
reviewed Edit suggested edit on Trigger to audit table changes