Reputation
479
Top tag
Next privilege 500 Rep.
Access review queues
Badges
2 7 20
Impact
~45k people reached

  • 0 posts edited
  • 0 helpful flags
  • 32 votes cast
May
21
awarded  Caucus
May
21
awarded  Constituent
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
accepted WorldWide site - should I save UTC or in fixed time?
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.