Home Forums SQL Server 2012 SQL 2012 - General how to speed retrieving data from big table data when select from it? RE: how to speed retrieving data from big table data when select from it?

  • December 17, 2018 at 12:03 am

    #2016453

    ahmed_elbarbary.2010 - Sunday, December 16, 2018 4:31 PM

    Problem

    I have table have 20 columns when make select data from new SQL query  computer hangs ?

    what suggestion to make quickly read data from this table and make performance good ?

    What I Try 

    ==========

    select * from table where 1=1 take 45 minutes 

    after minimize column number as 

    select column 1,column 2,column 3 from table also hangs but take less time as 42 minutes .

    when make select data from tables not other programs open only SQL server opened new query.

    table have 1 million records .

    Computer Capability

    ==============

    i work on SQL server 2012.

    select data from this table hangs computer although my computer capability not bad

    ram 8 GIGA and processor core I 5 .

    I try same Backup of data on another computer it take too much time as above ?

    ==============

    if possible what suggestions to select data quickly from table and best performance ?

    Both of your queries are attempting to return all the rows of data.  A WHERE clause with 1 = 1 is the same as no WHERE clause at all.  You want to speed up the query, reduce the number of rows you are trying to return.