Selasa, 11 Januari 2011

SQL SERVER: 9 Most Forbidden Things

DBCC SHRINKDATABASEMost of SQL Server developers and even some DBAs think that we can shrink size of a database by executing DBCC SHRINKDATABASE. You can just reacquire unused space of database and it’s never going to compress your database and change magically low size. Advantage is very very low as compared to performance loss. Why DBCC SHRINKDATABASE is so awful SQL Server Guru Pinal Dave has

Tidak ada komentar:

Posting Komentar