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 |
|
sagitariusmzi
Posting Yak Master
113 Posts |
 Posted - 2009-01-21 : 02:13:43
|
| " A table has the trilions of data, and has proper indexes as well,when we query the table, it got stucks.then how to get the records from that table ? "Please reply as soon as possible |
|
|
ra.shinde
Posting Yak Master
103 Posts |
Posted - 2009-01-21 : 02:15:24
|
| Will you please provide structure and indexes on table?Rahul Shinde |
 |
|
|
lionofdezert
Aged Yak Warrior
885 Posts |
Posted - 2009-01-21 : 02:17:03
|
| Did u apply partitioning ???Did u updated statistics ???And what about indexes fregmantation ??? |
|
|
|
sakets_2000
Master Smack Fu Yak Hacker
1472 Posts |
Posted - 2009-01-21 : 06:26:36
|
| I am sorry, but I find it really hard to believe a table having trillions of rows of data. Can you just check the exact count of rows once and post the number here if you don't mind. (I know this has nothing to do with your original question) |
|
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2009-01-21 : 07:01:21
|
| Also -- what's your query look like?Charlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-21 : 08:39:32
|
| Partition your table if its so huge. |
|
|
|
ssunny
Posting Yak Master
133 Posts |
Posted - 2009-01-21 : 11:15:57
|
| Try using NOLOCK in your select queries.But keep in mind that it will allow dirty reads. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-21 : 11:21:42
|
| Run sp_who2 active,sp_lock to see locking/blocking. |
|
|
|
|
|
|
Table Stucks on huge data