1,473 reputation
615
bio website
location Ukraine
age
visits member for 2 years, 1 month
seen 8 hours ago

Jul
24
revised sys.fn_varbintohexstr returns NULL if varbinary data is more then 2000 as datalength
fixed word order, added the footnote symbol near the product name referenced by the footnote
Jul
24
suggested suggested edit on sys.fn_varbintohexstr returns NULL if varbinary data is more then 2000 as datalength
Jul
24
comment LIKE uses index, CHARINDEX does not?
Do you happen to know if the PATINDEX() > 0 form uses the special statistics as well as the LIKE one?
Jul
23
comment Do database engines update when the updated value is the same?
@AdamB: It may still not be too late to do that.
Jul
23
comment Query taking non-consistent time to execute
Technically, you can edit your answer regardless of whether the question is on hold or nor (in case you were not aware). It is new answers that are prevented by the "on hold" status.
Jul
20
revised Space at the end of string
removed a tag from the title
Jul
20
suggested suggested edit on Space at the end of string
Jul
20
revised Space at the end of string
more clarification
Jul
20
awarded  Necromancer
Jul
19
revised Space at the end of string
clarified
Jul
19
awarded  Revival
Jul
19
revised Space at the end of string
improved formatting
Jul
19
answered Space at the end of string
Jul
19
suggested suggested edit on Space at the end of string
Jul
17
comment function hangs with null case operation
@MartinSmith: Bad statistics?
Jul
17
comment UPDATE statment with and without SELECT keyword
This is not an UPDATE...FROM statement. The FROM is a part of the (correlated) subquery, the SELECT. That is, your UPDATE statement has this form: UPDATE table SET column = (SELECT ... FROM ...), not this one: UPDATE table SET column = (SELECT ...) FROM .... In the latter case, the SELECT could indeed be omitted if it was just (SELECT scalar_expression). (Unless the expression included aggregate functions, but in case of (SELECT scalar_expression) using those wouldn't make much sense = unlikely.)
Jul
16
comment Run job once a minute, every day, except during a certain time
I've never tried this but I think I've seen that you can have multiple schedules on a single job. If so, create one for every minute on every day except Saturdays, and possibly two more for Saturdays, 12am till 7pm and 11:30pm till 12:59pm.
Jul
16
comment Need some support on MySQL Query
@ypercube's point is probably that your query doesn't appear to be selecting anything from cldetails or accounts and thus outer-joining those two tables doesn't change anything (except it may negatively affect the performance). Try removing them and look at the results after running the query without them to see if the results are correct and the performance improved.
Jul
16
awarded  Enthusiast
Jul
15
comment COUNT of rows with parent id equal to the row we have with a parent id of 0 in one query
group by is unnecessary, no?