Community Member Profile
ElKlaaso
Member since Dec 11, 2008
- Profile: /members/606-ElKlaaso.htm
- URL: x
- Comments: 1
- Points: 1
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.... read more »
