network profile
| bio | website | |
|---|---|---|
| location | ||
| age | 34 | |
| visits | member for | 1 year, 8 months |
| seen | May 15 at 6:14 | |
| stats | profile views | 51 |
If you don't build your dream , someone will hire you to build theirs
A quick tool i've built to find crossbrowser supports for :js,css,html5 features( scans both MDN and canIuse)
|
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. |
|
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 |
