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: 536
sql
|sql-server
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