title: Simple Select Query of 250K records takes 17 sec to run on SQl Server 2008 R2
body: <p>I have a simple table with 14 fields, all nvarchar, 11 are length 30, 1 length 12, 1 length 4, 1 length 2.  When I run Select query on the table to retrieve all records (250K) and fields it takes about 24 sec.  I figured with such a simple query it would be faster.  Is there any way to speed this up?<br>
  In the execution plan Table Scan, I/O cost is 5.36979, CPU Cost 0.275, Operator cost 5.6449, subtree cost 5.6449, row size 395b.  Adding a Cluster Index reduces it only by about 5 secs.
  Please Help!</p>