Friday, February 24, 2012

Is DBCC shrinkfile faster then the EM equivalent ?

Using SQL 2000 and wanted to know if DBCC shrinkfile executed from QA is
faster than doing the equivalent through Enterprise Manager by selecting the
file and selecting shrink file to <size>
Thank youIts exactly the same code.
--
Paul Randal
DBCC Technical Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:#LuLYI#VDHA.1832@.TK2MSFTNGP09.phx.gbl...
> Using SQL 2000 and wanted to know if DBCC shrinkfile executed from QA is
> faster than doing the equivalent through Enterprise Manager by selecting
the
> file and selecting shrink file to <size>
> Thank you
>

No comments:

Post a Comment