Reputation
4,355
Top tag
Next privilege 5,000 Rep.
Approve tag wiki edits
Badges
1 14 34
Newest
 Suffrage
Impact
~166k people reached

Jan
26
revised MySQL replication - invalidating query cache entries (table)
formatting, spelling
Jan
26
reviewed Reviewed Performance of a self join in a temporal table with a single day's difference between end_date and start_date
Jan
26
answered Set variable with dynamic name in trigger (MySQL)
Jan
25
reviewed Close Difference between execution times
Jan
25
reviewed Leave Open Should I add an arbitrary length limit to VARCHAR columns?
Jan
25
revised Avoid double query on the same table
deleted 9 characters in body
Jan
25
answered Avoid double query on the same table
Jan
25
revised SQL OrderBy When using an In() query
corrected the function's author's name
Jan
25
comment Grouping by each user's statuses or activity datetime
What is the actual issue you are trying to solve with this question then? Are you looking for ways to identify a group ("island") of activities that have happened in a short span of time? Or is this about how to include activities that belong to the last group selected with SELECT ... LIMIT n but didn't make it to the results because of the LIMIT? Both are good questions but I believe they are separate problems (and so should be asked about separately). And it's the latter one that I believe could be solved with equal ranking (provided the groups are already identified and can be sorted).
Jan
24
reviewed Leave Open Should I have a column for every data type or 1 column that stores everything
Jan
24
reviewed Reviewed Slow query performance on large table with no unique keys
Jan
24
reviewed Reviewed How to get SQL insert and/or update to not lock entire table on MS SQL Server
Jan
24
reviewed Close Restored database from .bkp file in SQL Server 2014 generates some strange errors
Jan
24
reviewed Close Change SELECT DISTINCT to UPDATE DISTINCT
Jan
24
reviewed Close Should I look into alternatives to a relational database?
Jan
23
revised SQL Server: Query Efficiency Having vs Subquery
added a missed detail
Jan
23
comment SQL Server: Query Efficiency Having vs Subquery
@DanielHutmacher: I don't think there is any evidence that pd_dt is not a datetime or datetime2. The OP may be casting it to date simply to cover whole days.
Jan
23
comment SQL Server: Query Efficiency Having vs Subquery
I think it would be a covering index even if pd_dt was the only key column, al the others being in INCLUDE.
Jan
23
answered SQL Server: Query Efficiency Having vs Subquery
Jan
22
revised ER Diagram - subclass Entity constraint
typos