Raghavendra Mudugal (8/21/2014)

---

TomThomson (8/21/2014)

---

It's valid...

Those two are just Perfect!!

Grant Fritchey (8/22/2014)

---

I hadn't heard, but now that I know... I'm bummed. They made the show...

In other news, what does everybody think of the Mythbusters news from last night?

Jack Corbett (8/22/2014)

---

SQLRNNR (8/22/2014)

---

Ed Wagner (8/22/2014)

---

The bug that was afflicting the thread is fixed!!! Thanks very much, Steve. I, for one, have missed the water cooler....

Koen Verbeeck (8/22/2014)

---

SQLRNNR (8/22/2014)

---

Ed Wagner (8/22/2014)

---

The bug that was afflicting the thread is fixed!!! Thanks very much, Steve. I, for one, have missed the water cooler. 😉 ...

Ed Wagner (8/22/2014)

---

The bug that was afflicting the thread is fixed!!! Thanks very much, Steve. I, for one, have missed the water cooler. 😉 If you're so...

I hope that...

Hany Helmy (8/21/2014)

---

Never used TABLOCK option with DBCC before, always using:

DBCC CHECKDB WITH NO_INFOMSGS, ALL_ERRORMSGS, TABLERESULTS;

DBCC CHECKDB WITH PHYSICAL_ONLY; -- Best Practice

So I had to read the documentation carefully, then...

This question highlights another great example of bad (conflicting) documentation.

Within the same documentation one will find both of the following statements.

And

Unless NOINDEX is specified,...

quackhandle1975 (8/20/2014)

---

It might not be for the OP requirements but do remember SQL (from 2008 onwards) comes with it's own (FREE) Data Collector which generates basic, but quite insightful reports.

Also...

smtzac (8/19/2014)

---

Thank you SQLRNNR. sorry, I am trying to explain better way:

There is a log file 100 GB. New transaction occurs and it shows 125 GB log file backup...

Yes. Here is an article on that.

http://msdn.microsoft.com/en-us/library/ms159762.aspx

I mean, does the test_create table that you provided represent

or

or

from your original query that you posted?

Which table is test_create supposed to represent?