Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.
Ben Nadel at CFUNITED 2008 (Washington, D.C.) with: Dee Sadler
Ben Nadel at CFUNITED 2008 (Washington, D.C.) with: Dee Sadler@DeeSadler )

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 »