Table fragmentation in SQL server

Posted by Joseph on Stack Overflow See other posts from Stack Overflow or by Joseph
Published on 2010-05-19T11:10:19Z Indexed on 2010/05/19 13:00 UTC
Read the original article Hit count: 540

Filed under:
|

Hi Anybody have an idea about Table fragmentation in SQL Server(not Index fragmentation).We have a table ,this is the main table and its not storing any data permently,dat come here and goes out continusly. there is no index on this because only insert and delete staements are running frequently. recently We face a huge delay for the response from this table. If we select anything it tooks more than 2 to 5 minuts to return result,even there is very few datas. At last we delete and recreate this table,and now its working very fine. Appreciate If any comments,how this is happening ?

Joseph

© Stack Overflow or respective owner

Related posts about sql

Related posts about sql-server