Disappointing, indeed.

Another reason to actually put your lobs in a separate filegroup.

Keep in mind I can only carry up to 25kg of goods in my filght case 😀

(I should double check that weight limit)

Indeed, the cleantable isn't common with your request.

I was especially aiming for:

There is a known issue where on a database having a LOB data in it, the SHRINK operation will...

@Brandie Tarvin

Yes.

It's something you'll have to get used to, because it comes in handy, but may also bite you in the back because you forgot you were having a...

Did you have a look at http://www.sqlservercentral.com/Forums/FindPost1008735.aspx

It contains nice feedback info from MS.

Maybe Paul Randal has more info on that at http://www.sqlskills.com/blogs/paul/post/checkdb-from-every-angle-emergency-mode-repair-the-very-very-last-resort.aspx

Thank you for sharing !

Many people didn't find this setting.:ermm:

With sql2008 that option is included with the right-click on the grid. :w00t:

You should be able to find who/what caused your dblog to grow if you have your default trace active.

ref: "Did we have recent autogrow?" by Tibor Karaszi

http://sqlblog.com/blogs/tibor_karaszi/archive/2008/06/19/did-we-have-recent-autogrow.aspx

If that doesn't get...

Need it to be said that from an OLTP database perspective only R2 doesn't have that much an advantage over the original.

We are skipping the original because of report server...

Thank you for the great feedback.

Since it seems so dificult to alter the sa password ....

this must be another reason NOT to use sa !

If you need sysadmin auth, which 99.99999% of the apps will...

AFAIK there is no @@connectionIPaddress, but you can use this DMV to get this info

Select client_net_address

from sys.dm_exec_connections

where session_id = @@spid

A regular user (=non sysadmin) by default only gets to...

If I'm correct, datadude (visual studio for DBA) has that functionality, in case you're searching for other means than sql itself.

HTH.

Most of us still fall in that trap every once in a while.;-)

Jeffrey Williams-493691 (10/24/2010)

No, I don't think a full backup will be any smaller because of backing...