Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
FaisalMaqbool
Starting Member
1 Post |
 Posted - 2009-09-10 : 05:55:09
|
A few days ago i have came across a problem that a table which was accessible last day was not being queried. I have write a 'select top X * from Table_name'. Its retrieving data for a small amount of data (200000) out of 3000000 but if i increase the value of 'X' in the statement with 'select top' the query never returns.
Any suggestions what has happened ?
I have truncated the table and loaded with data less the the day error has occur and its working fine .... but i need to investigate what has happened the day when data was not get retrieved from that table.
Please let me know if more details are required. |
|
|
|
|
|
Table unaccessable