Sorry, I got to clearify that I do not want to remove all rows.

I need to delete from a specific criteria.  I am mistaken, but

Truncate table will not work for...

Yes, You should turn on the atuo create stats and on nightly basis run the update statistics job.  You do not need to run sp_refreshview if you are including the...

Don't worry guys, I got it resolved.  We shrink the data file and after that, we can removed the filegroup!  Strange right? 

But it worked.

thanks, TEAM@!!!

Jon

Thanks to Sherri for pointing out that article.   I had followed the instructions and remove all the empty files.  I think SQL server create server statistic and I had to...

I am glad that I got rid of those stats tables...so I can removed all the empty filegroups!

Thanks!

I am not sure how to help you on that,  Nevertheless, I am interested to know if you can help me out with my log shipping.  For two days now,...

Good point... I think I might just recommend client to put SQL on a 4 way box by itself....

I still wanna to know the specific driver conflict issues.... and...

Do you have specific driver conflict examples? We are working with a large windows system 8 CPU and client want to consolidate as many DB as possible.

Really...