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.

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
7
asked WorldWide site - should I save UTC or in fixed time?
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 ) ?
May
1
accepted Force sql server to run query conditions as written?
May
1
asked Force sql server to run query conditions as written?
Apr
28
comment Unable to connect to SQL server 2008 R2 via Instance name?
Thank you very much Mikael.( as always :-))
Apr
28
accepted Unable to connect to SQL server 2008 R2 via Instance name?
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" ?
Apr
28
asked Unable to connect to SQL server 2008 R2 via Instance name?
Apr
16
awarded  Popular Question
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?