Question : When running show warnings in mysql, sometimes the results give a row number, such as “Warning | 1265 […]
Tag: warning
MySQL: Why am I getting this warning?
Question : I am calling the stored procedure below, and get this warning, is this warning a false positive or […]
Should I be alarmed by this NO JOIN PREDICATE warning?
Question : I’m troubleshooting the bits and pieces of a poorly-performing stored procedure. This section of the procedure is throwing […]
Indexing every WHERE column?
Question : I tried to turn on MYSQLI_REPORT_ALL | MYSQLI_REPORT_STRICT and now MySQL tells me: No index used in query/prepared […]
Indexing every WHERE column?
Question : I tried to turn on MYSQLI_REPORT_ALL | MYSQLI_REPORT_STRICT and now MySQL tells me: No index used in query/prepared […]
MySQL “Statement may not be safe to log in statement format” warning
Question : What is the meaning of the following MySQL warning: Statement may not be safe to log in statement […]
Conversion may affect “CardinalityEstimate” CONCAT NVARCHAR and UNIQUEIDENTIFIER
Question : So I have a temporary table with only one column NVARCHAR(400). In this temp table, I Insert values […]
When does SQL Server warn about an Excessive Memory Grant?
Question : What are the conditions that produce an “Excessive Grant” execution plan warning? The query memory grant detected “ExcessiveGrant”, […]