Seeing slowness in insert/select after truncating a table that has over 6 million rows.
I daily insert 5 to 6 millions records into a table and I was able to insert/select data without any issue for some 7 or 8 days but when the table size went above 10 GB / 30 million rows, there were a few timeout issues.
So I thought of truncating the table daily before data uploading since 1 day's data is enough for me. Now I am seeing extreme slowness after truncating. I am using sql server 2008.
do i need to update table stats? or is it some thing related to ghost rows?