Russell Shilling (12/10/2010)

---

I run shrink on our Dev server after running lots and lots of queries to reduce the transaction log size (on disk). It's easy to grow a...

pjdiller (12/10/2010)

---

SanDroid (12/10/2010)

---

pjdiller (12/10/2010)

---

Ultimately, my question is whether...

CirquedeSQLeil (12/10/2010)

---

As a manual process for very specific reasons (such as Gail mentioned), shrink should remain. I think it needs some fixing done but it should stay in SQL...

Hugo Kornelis (12/10/2010)

---

Well, I don't know about others, but for me this is one of...

pjdiller (12/10/2010)

---

Ultimately, my question is whether that is...

Actually it is...

What would be left if we deprecated everything that seems buggy when mis-used?

I agree with the comments already made by Hugo and Gail. They are close to what I...

Most QOTD readers that actually run or test the QOTD scripts do so in a default NON Production installation of...

Nils Gustav Stråbø (12/9/2010)

---

That's cheating in my world...

I took the...

Artur Komkov (12/9/2010)

---

What's why I always try to avoid nullable columns or make something like that:

select * from dbo.Employees where EmployeeID

not in...

David Bird (12/8/2010)

---

SanDroid my visual tests show the results are the same for both scripts except that TravisDBA script does not handle tables with a dbo schema. I do not...

tilew-948340 (12/8/2010)

---

select * from dbo.Employees where (EmployeeID <> NULL) and (EmployeeID <> 0) and (EmployeeID <> 1)

select * from dbo.Employees where (EmployeeID = NULL) or (EmployeeID = 0) or (EmployeeID...

WOW!!!

Two good replacement scripts.

However there is great sadness for the readers and users.

Each script returns a differant value in KB for [Reserved].:w00t:

Travis:

TABLE_USERTABLE_NAMEROWSRESERVED_Kb

dbo ...

Thank you William for posting some code that actually will execute here.

The other code posted in the article would not execute in SQL 2008 R2 SSMS.