Reputation
541
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
3 7 22
Impact
~57k people reached

  • 0 posts edited
  • 0 helpful flags
  • 33 votes cast
Jan
30
awarded  Popular Question
Jan
16
comment Row_number and wrapping select ?
Martin , so why it doesnt returns 4 rows here sqlfiddle.com/#!6/20179/2 ? (2 per partition i mean)
Jan
16
comment Row_number and wrapping select ?
Martin , top(1) is PER partition...right ? ( I did see in the fiddle) but didnt know it is possible. ( just making sure). ALSO , I could also use top(2) which will provide the 2 oldest. so ...where is the catch (you wrote generally...)?
Jan
16
comment Row_number and wrapping select ?
Thank you very much
Jan
16
accepted Row_number and wrapping select ?
Jan
16
comment Row_number and wrapping select ?
@ypercube not a problem , Just want to expand my knowledge.
Jan
16
comment Row_number and wrapping select ?
@ypercube what ? I do use it ! the problem is how to read the value ( what other options I have , except wrapping in select)
Jan
16
asked Row_number and wrapping select ?
Jan
14
accepted SQL Server help tables?
Jan
14
asked SQL Server help tables?
Dec
29
comment Sql server update query locking stages?
"scan"= will it have to recalculate the where clause in the second query ?
Dec
28
comment Sql server update query locking stages?
Can you please answer my last comment
Dec
28
comment Sql server update query locking stages?
But if the second query of yours got an update lock and now it is waiting for the first query to complete , and now ( after the first one is finished) - the where clause does not match any rows ? I mean : let's say that the first query of yours is update HumanResources.Department set name = 'This is a new name' , Departmentid=12 where DepartmentID = 11;.....so now the second query thinks it is going to update some rows(it's waiting to get execlusive lock !) , but now there arent any rows of departmentid=11.....will it scan the table it again ?
Dec
26
comment Sql server update query locking stages?
+100 thank you very much.
Dec
26
accepted Sql server update query locking stages?
Dec
24
asked Sql server update query locking stages?
Dec
12
comment SQL Server Profiler behavior?
Thanks mike. i truly hope it doesn't throw if it wasn't told to...:-)
Dec
12
accepted SQL Server Profiler behavior?
Dec
12
awarded  Critic
Dec
12
comment SQL Server Profiler behavior?
ps there is a difference in your answer between captured or sent ( it is not the same thing). Sql throws a ball(an sp has executed). I dont care who is catching the ball( trace) I just ask if sql trully throws the ball.(sending) even if there is no one to get the ball.