title: SQL Server Table Simple Select Query taking too long
body: <p>I have a simple table in MS SQL Server.</p>
  
  <pre><code>CREATE TABLE [dbo].[Personas] (
  [Name] varchar(250) NOT NULL,
  [ID] varchar(250) NOT NULL,
  [IntranetID] varchar(250) NULL,
  [eMail] varchar(250) NULL,
  [Number] varchar(50) NULL,
  [ModifDate] datetime NULL)
  ON [PRIMARY];
  </code></pre>
  
  <p>After truncating and inserting data again to this table, I'm unable to do a simple select query or a simple count query. The process tasks keeps running without ending. However I can query successfully on other tables except this one.</p>
  
  <pre><code>select * from Personas;
  select count(*) from Personas;
  </code></pre>
  
  <p>How can I know the reason why this is happening and how can I fix it?
  There are no error message on the queries so I don't know what are the errors. How can I know if the table was corrupted?</p>
  
  <p>I'm not expert in SQL Server administration but I tried to execute below. I'm not sure if this is the reason, and how to fix this if it is.</p>
  
  <pre><code>DBCC SQLPERF(logspace)
  
  Result:
  Log Size (MB) = 19.6
  Log Space Used (%) = 78.79
  Status = 0
  </code></pre>
  
  <p>Please kindly help. Thank you in advance.</p>