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
Langganan:
Posting Komentar (Atom)


Tidak ada komentar:
Posting Komentar