title: would selecting on too many fields cause a table lock?
body: <p>I have a SELECT statement in a stored procedure that under very heavy load results in a timeout: "Lock request time out period exceeded." - at least that's what .NET throws. It is a pretty simple query on a table (CODES) that has a primary key and a clustered index (on TYPE_CODE1). The only thing that looks out of the ordinary is that there are many fields being selected on (all the fields except Dclass are bit fields). Would this cause the lock on the table? Any other ideas?</p>
  
  <p>TIA<br/>
  T</p>
  
  <pre><code>select
  @TYPE_CODE1 = TYPE_CODE1,
  @ALTERNATE_CODE = ALTERNATE_CODE,
  @BANNER = BANNER,
  @CODE_1 = CODE_1,
  @CODE_2 = CODE_2,
  @CODE_3 = CODE_3,
  @CODE_4 = CODE_4,
  from CODES with (nolock)
  where
  Dclass = @Dclass
  and Ret = @Ret
  and Rem = @Rem
  and Ope = @Ope
  and Res = @Res
  and Cer = @Cer
  and Cdo = @Cdo
  and Del = @Del
  and Sig = @Sig
  and Ads = @Ads
  and Adr = @Adr
  and Emi = @Emi
  and In1 = @In1
  and In2 = @In2
  and Paa = @Paa
  and Reg = @Reg
  and Red = @Red
  and Rer = @Rer
  and Ree = @Ree
  and Rei = @Rei
  and Spe = @Spe
  and Mer = @Mer
  and Hol = @Hol
  and Day = @Day
  and Sca = @Sca
  and Sis = @Sis
  and Poa = @Poa
  and Haz = @Haz
  and Sun = @Sun
  and Out = @Out
  and IsActive = 1
  </code></pre>