439 reputation
718
bio website
location
age 35
visits member for 3 years, 2 months
seen Nov 11 at 10:17
  • My Online C#5 spec — My colored clarified version.
  • NG-print — Use it to print the angularjs documentation.
  • Code Liner — Use it to paste code with line numbers to reference by you or by others.

Aug
5
comment CTE query doesn't print the right structure?
Thank you very much Sebastian
Aug
5
comment CTE query doesn't print the right structure?
@AaronBertrand Thanks a lot. didn't know that. anyway I hope that this issue of mine (which i'm struggling with for days) - will finally be solved here....
Aug
5
comment CTE query doesn't print the right structure?
@AaronBertrand I'm about to delete it in SO. ( I think it is better to ask here)
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)