network profile
| bio | website | |
|---|---|---|
| location | ||
| age | 34 | |
| visits | member for | 1 year, 8 months |
| seen | May 15 at 6:14 | |
| stats | profile views | 51 |
|
May 8 |
comment |
WorldWide site - should I save UTC or in fixed time? @billinkc I read it. but can you explain the actual problem here ? does the actual problem is that a time can occur twice ? please elaborate. |
|
May 7 |
comment |
WorldWide site - should I save UTC or in fixed time? Thank you Remus.So the only problem is with daylight saving where a time could happend twice ( ? becuase of changing the clock to one hour prior ? ) |
|
May 2 |
comment |
Force sql server to run query conditions as written? @StrayCatDBA does it mean that my query will run as written ? (in my desire order ) ? |
|
Apr 28 |
comment |
Unable to connect to SQL server 2008 R2 via Instance name? Thank you very much Mikael.( as always :-)) |
|
Apr 28 |
comment |
Unable to connect to SQL server 2008 R2 via Instance name? Thanks. and what If I choose "lala" as instance name ? would then I be able to cennect via ".\lala" ? |
|
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 |
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) |
|
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 12 |
comment |
SQL Server Profiler behavior? Thanks mike. i truly hope it doesn't throw if it wasn't told to...:-) |
|
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 |
comment |
Get the windows account which runs the query? @RemusRusanu it is from a paper not a board. :-) but thanks |
