424 reputation
717
bio website
location
age 35
visits member for 2 years, 10 months
seen Jul 21 at 7:01
  • NG-print — Use it to print the angularjs documentation.
  • signalR-print — Use it to print the signalR documentation.
  • Code Liner — Use it to paste code with line numbers to reference by you or by others.
  • CanIUse 3 — Use it to quickly check browser compatibility with the most 2 popular ways.

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.
Dec
12
comment SQL Server Profiler behavior?
If you don't select the event, that event isn't captured or sent that helped. So if i do not select to monitor sp's , sql server will not throw events for sp's right? ( i dont care about who is catching those event , i just care if sql throw events of sp's)
Dec
12
comment SQL Server Profiler behavior?
After an event occurs, if the event class has been included in a trace definition... trace definition can contain (or not) event to listen. but does the event source EMITS IT at first place ?
Dec
12
comment SQL Server Profiler behavior?
@ThomasStringer I didnt understand from it if it emits all event from event source !
Dec
12
asked SQL Server Profiler behavior?
Dec
12
accepted Get the windows account which runs the query?
Dec
12
awarded  Editor
Dec
12
revised Get the windows account which runs the query?
added 47 characters in body
Dec
12
comment Get the windows account which runs the query?
@RemusRusanu it is from a paper not a board. :-) but thanks
Dec
12
comment Get the windows account which runs the query?
I need to tell the IT manager : "please grant access to ____" . Is three any select account which shows me the value of "______" ?
Dec
10
comment Get the windows account which runs the query?
will the 'whoami' result and the service account will always be the same ?
Dec
10
comment Get the windows account which runs the query?
Thank you ( as always).