Joy Smith San (10/17/2014)
That depends. Are you rebuilding those unwanted indexes? Are you rebuilding all of your indexes? Or are you using a defrag process that is more intelligent and only targets the indexes that need to be rebuilt?
Yes, they rebuild all indexes once in a week.
So if we rebuild only those indexes which are required, will it be using less log space ?
Thanks.
Building on what Grant said, if you have a 5GB index that you are rebuilding you will need 5GB. But if you don't need to rebuild that index then you won't need that space in the transaction log.
If you need something that helps with intelligent defrags, the best script out there is by SQLFool (Michelle Ufford). It's a starting point since any routine should be relevant to the environment and you should build the routine to suite the environment.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events