Browse by Tags

• Career
• Oracle
• programming
• SQL Server

• SOT: I found a new 'worst query'

  Before you ask, SOT means Slightly Off Topic :-()) Take a look at Hi, I need help on simplyfying this Update query! I don't even want to count the nested SELECTS, The query is 688 lines long, somehow schadenfreude enters my mind. Read More... Posted Thursday, March 20, 2008 4:31 PM by Denis Gobo | 4 Comments Filed under: Sad but true

• SQL Sentences

  Why not store all of the SQL queries in the database? http://thedailywtf.com/Articles/SQL-Sentences.aspx Read More... Posted Monday, February 25, 2008 12:15 PM by Denis Gobo | 5 Comments Filed under: Sad but true

• The Sad State Of Programmers Part 2 : The In Person Interview

  This is part two of a three part series. Part one was about the phone interview , this part is about the in person interview. Part 3 is about general tips The point of the in person interview is to see if the person will fit in with the rest of the people Read More... Posted Monday, December 10, 2007 3:54 PM by Denis Gobo | 21 Comments Filed under: Career, programming, Sad but true

• The Most Natural Set Option

  SET ANSI_NULL_DFLT_OFF ON this is what this means, in English.... Set the setting ANSI NULL Default Off to ON Why not just SET ANSI_NULL_DFLT [ON|OFF]? This is even worse than SET NOCOUNT ON Oh well..... Read More... Posted Wednesday, December 05, 2007 2:35 PM by Denis Gobo | 4 Comments Filed under: Sad but true

• Perfect way to manage a database project.........not!

  I found this gem yesterday here: http://www.tek-tips.com/viewthread.cfm?qid=1391668&page=1 here is the question I have a situation where a person can have more then one item ordered. I need to layout the information as follows: Person Item Ordered Read More... Posted Thursday, July 26, 2007 9:08 AM by Denis Gobo | 1 Comments Filed under: Oracle, Sad but true, SQL Server