Log_reuse_wait has nothing to do with the log not shrinking. It tells you...

Jason A. Long (5/19/2015)

---

Unfortunately, it appears that the conversion does cause a performance hit. Executing Dave's test code with and without the CONVERT(CHAR(10)...), showed the non converted version consistently executing...

Well, yes, of course it will. VLFs have a certain max size...

Please, please, please get and read that book.

Most of the waits in the picture are ones we don't care about (sleep is supposed to be high). There's a script in...

ramana3327 (5/19/2015)

---

so if the log file initial size is 50MB and we started reorg indexes job, then it grows 160GB. So we can't get that initial physical log size (50...

No, and rebuild doesn't use TempDB instead of the log either. Rebuild uses TempDB for sort space, space that would otherwise come from the user database's data file. Reorganise doesn't...

SQLRNNR (5/19/2015)

---

Continue to mark the answers from applicants as correct for questions you just discovered were wrong (well because it is a common myth so why punish them)?

Or do you...

Don't fixate on one thing, you need a lot of stats and a lot of information to start diagnosing.

You lose any permissions that were on the object, if that can be called an advantage.

https://msdn.microsoft.com/en-us/library/ff878487.aspx -- the 2014 BoL

https://msdn.microsoft.com/en-us/library/ff878487(v=sql.110).aspx -- the 2012 BoL

Each server instance must be running the Enterprise Edition...

A stats set and an index aren't duplicates and...

Well shrinking's never destructive.... I said it's bad practice, not that it's going to destroy something.

Yes.

Cross-version is only for rolling upgrades, not as a permanent scenario.

Yes. Do not...

Pretty much. By adding one day to the end of the range, you're getting all the date-times on that day, right up to just before midnight at the end of...