Table hints

• wizeguy

  SSC-Addicted

  Points: 468

  More actions

  November 20, 2003 at 10:04 pm

  #176950

  Hi All, what's the skinny on using table hints, (nolock), (rowlock) etc.. on Read-only databases? Is it worth using these hints?

  what are the cons? Does using hints eat up sql memory?

  Adios..

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  November 21, 2003 at 12:20 am

  #483004

  Lots of stuff around here

  http://www.sqlservercentral.com/sitesearch/cgi-bin/es/esearch.asp?start=0&perPage=10&summary=yes&sort=rank&search=hint

  Frank

  http://www.insidesql.de

  http://www.familienzirkus.de

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]