Exploring Thoughtz..

Posts Tagged ‘SQL

Learnings

Posted by: Vijay Dev on: May 20, 2009

Got a laptop and not blogging at all ? What the hell am I doing ?! Actually I wanted to write about all those small things that I learned in the last week or so, but could not manage to get past my laziness
Learned how to use temp tables in SQL Server, how [...]

SQL Collations & Case Sensitive Searches

Posted by: Vijay Dev on: April 14, 2009

I got a question recently from a friend about doing case sensitive searches in SQL and I did not know the answer !! I knew that ORM’s like Django have operators such as ILIKE to do this, but I do not know how to do this in raw SQL. So I started looking for ways [...]

MS SQL – DateTime related Functions

Posted by: Vijay Dev on: August 24, 2008

Many a times I have come across code snippets that either format a timestamp value for displaying to the user or compare with another timestamp value. Often its much easier to let the database do the same. However, since the database needs to use functions on the columns to do these conversions, indexes on these [...]

My Amazon Interview Questions

Posted by: Vijay Dev on: September 19, 2007

When I attended Amazon off campus interview a few months back, I recorded the experiences there as a page. Since I no longer like it being there (reminding me that I was a student ), I had removed it. But here’s the content of that page -
I attended Amazon Off campus on 24th Jan [...]


Blog Stats

  • 22,081 Visitors

  • Yann: Hello! Could you expand your example for the a bit not-so-hapy java users like me, and describe how to compile and run your code? That would be awesom
  • Anuraj Pandey: Some one is mis-using my id..i got the notification of the above comment..however i havent posted the comment :(
  • Anuraj Pandey: if u have some kind of pdf/text of the material u removed..it will be highly appreciable if u help me..i have my first google intern telephonic interv

My Tweets

About Me

Journey so far…