Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.
Ben Nadel at CFinNC 2009 (Raleigh, North Carolina) with: Andy Matthews and Doug Hughes
Ben Nadel at CFinNC 2009 (Raleigh, North Carolina) with: Andy Matthews@commadelimited ) and Doug Hughes@doughughes )

ElKlaaso

Member since Dec 11, 2008

Recent Blog Comments By ElKlaaso

  • SQL Server NOLOCK / ROWLOCK Directives To Improve Performance

    Posted on Mar 5, 2007 at 2:18 AM

    Guys, i am not sure if i agree with your denormalized database schema. A 200 column table is very slow, instead you could have used covering indexes (which doesnt work anymore in a denormalized table), and combine it with (NOLOCK). If the reports are still slow, get more RAM for your sql server. If ... read more »