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

Feb
3
comment Get start time and end time of a trip in SQL Server
It'll be great if you show us what you have tried. That way you may be more likely to learn something new rather than just get another proverbial fish for a day.
Feb
2
comment Recursive Join to get Spans
Solutions for Oracle and for MySQL would likely differ very much. Or, if a universal one is possible, it's probable that it wouldn't be very efficient for this type of problem. I suggest you stick with Oracle in this question and, if you need a solution for the other platform as well, ask a new question for MySQL. (But please make sure you've searched for ready answers. I'm sure questions of this kind have been asked before both here and on Stack Overflow. Search either site for [gaps-and-islands] [mysql].)
Feb
2
reviewed Leave Closed How to get data from three different tables
Feb
2
reviewed Close What can become a reason of database failure?
Feb
2
reviewed Close How to get data from three different tables
Feb
1
reviewed Close Index Maintenance taking long time - Primary Key (Clustered Index) Varchar(35)
Feb
1
reviewed Close Stored procedure execute another sp with random value of parameters
Feb
1
reviewed Looks OK Where clause from OUTER APPLY using LEFT function
Feb
1
reviewed Close I don't want to have the error when I drop a table although the table doesn't exist
Feb
1
comment Updating next record
Could you please post your example in the form: data sample before the update, then the same data sample after the update (expected result)? And not in a comment but in the question, because that seems important to understanding your problem correctly. Thank you.
Feb
1
comment Why does the first query scan and the second seek?
You could post it at pastebin.com and link to it in your question.
Jan
31
reviewed Close How to get the sum of a particular item id in a column
Jan
31
reviewed Close SQL Server 2014 Batch Transaction Log Management
Jan
31
reviewed Close difference between assingment and :
Jan
29
comment Query with join to a table on a different database need an index
If the indexing route is no go (since you don't have the necessary permissions), perhaps we could take a look at the actual query?
Jan
29
comment Query with join to a table on a different database need an index
@Frisbee: A view cannot be indexed unless it was created with schema binding. And if they just create a view and use it, that will hardly have much effect, performance-wise.
Jan
29
reviewed Edit function execution related question
Jan
29
revised function execution related question
cleaned up a little more
Jan
29
reviewed Close Complex view becomes slow when adding ORDER BY in outer query with small LIMIT
Jan
29
comment Ordering in postgresql
Why are there no dates in your example?