This might be something Mladen Prajdic would consider adding to his popular "SSMS Tools Pack" add-in, should be very quick to include! Have you considered contacting him to find out?

I...

Awesome thanks! I'll be linking the test scripts in as demo queries at some point over the next couple of days - having fun with the GitHub API.

This is maybe slightly offtopic and a year late in coming, but I just fed this query in to my T-SQL formatter (I swear I didn't specifically prepare for this...

Bob, to be fair, the CLR stored proc that I linked is much more complicated than it needs to be for your purposes - I wanted to support a variety...

Hi, FYI, I did something similar to this using a SQL CLR stored procedure, it actually works pretty well! Doesn't handle the "ROOT" option yet, but should work for most...

I know this topic is long-dead, but in case someone finds it while searching for LOB unused space issues, the following topics deal with (what looks like) the same issue...

I know this topic is long-dead, but in case someone finds it while searching for LOB unused space issues, the following topics deal with the same issue and offer a...

ALZDBA (10/26/2010)

---

I was especially aiming for:

There is a known issue where on a database having a LOB data in it, the SHRINK operation will only shrinks one empty LOB extent...

Yep (linked above), but it didn't seem quite on-target or I misunderstand something:

Considering the above know behavior of SQL , which is by...

jghali (6/4/2010)

---

...

Create Database Mytestdb

on

( name ='Mytest_1', Filename= 'C:\MyTEST.mp3', size = 2000 KB

)log on(

name ='MyTest_2', Filename= 'C:\MYTEST.doc', size= 512 kb)

...

CREATE FILE encountered operating system error 5(Access is denied.) while attempting to...

eric_russell 13013 (5/24/2010)

---

a system that sits in the background, invisible to those who don't want to know while also transparent in it's function to whose of us who do want...

Yep, totally agree; I suspect we need laws governing not only how companies need to treat data they have on individuals (as already exist in europe, however impractical and ill-enforced)...

Scott Duncan-251680 (5/2/2010)

---

Good question but just raises another for me - when would you use NULLIF? It may be useful, but I am struggling to see where you would...

I'm not sure my theory is that interesting, I suspect that I just misunderstood what Hugo was saying...

Hugo Kornelis (4/23/2010)

---

The log file will contain only the fact that page so-and-so was deallocated, but the log backup (if one is taken) will also include a copy of that...