October 2007 - Posts

• Normalization's other little side effect...

  It isn't that I don't like a challenge, really it isn't. I like puzzles, mazes, Suduko, video games with challenging levels where I have to really think about a problem to solve it. So why don't I like poorly designed databases, where finding a value Read More... Posted Sunday, October 7, 2007 2:56 PM by drsql | 2 Comments

• sys.dm_exec_sql_text

  (Edit: Was reading Adam's book tonight and discovered you can pass a plan handle to this object. Very interesting!) This dynamic management object returns the SQL that was saved when a query was executed. This is a very exciting and useful thing to have, Read More... Posted Wednesday, October 3, 2007 11:53 PM by drsql | 1 Comments