Home Forums SQL Server 2005 Administering SQL 2005 - SELECT query takes long time to retrieve RE: SQL 2005 - SELECT query takes long time to retrieve

  • July 20, 2010 at 7:38 am

    #1195512

    select * from table_name where [time] between

    '2009/6/1 6:00am' and '2009/6/30'

    no indexes,triggers etc. Field [time] has datatype datetime.