title: How to improve performance of select queries from table with lots of columns
body: <p>I have a table with almost 100 columns. The type for most of the columns is <code>Nvarchar(50)</code>.</p>
  
  <p>When I select rows by query, it takes a long time, depending on the number of rows. Now, the table includes 250,000 rows. It takes a a full minute to get all the rows when I execute:</p>
  
  <pre><code>SELECT * FROM Table1
  </code></pre>
  
  <p>I tried to add indexes, but it didn't shorten the time.</p>
  
  <p>How can I build this table in a better way, so that the query's execute time will be shorter?</p>
  
  <p>I'm using SQL Server 2014.</p>