Every new client and often times with new projects for old clients.

hisakimatama (5/6/2014)

---

SQLRNNR (5/6/2014)

---

hisakimatama (5/1/2014)

---

Whew, busy times at work lately. I've been out of The Thread for a good bit :-).

Anyone else from The Thread planning to attend this week's...

Revenant (5/6/2014)

---

Beatles

Stuart Davies (4/29/2014)

---

dog (springer spaniel)

hisakimatama (5/1/2014)

---

Whew, busy times at work lately. I've been out of The Thread for a good bit :-).

Anyone else from The Thread planning to attend this week's SQL Saturday...

jcox 10222 (5/5/2014)

---

Has this been completed? If not I'd like to give it a crack. Also do you want to mention any free tools you can use to...

I haven't taken any of the IE courses by SQLSkills so couldn't compare what is actually on the slides and the context.

But from what you posted it looks like the...

Excellent question

yes please.

Eric M Russell (4/23/2014)

---

I believe that performing a clustered index reorganization is always an online operation, and LOB_COMPACTION (on by default) will also reclaim deallocated LOB pages, which is what...

Here's an alternative query you could try. Keep in mind it could be a heavy load on a production box.

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;

GO

/*

For statement optimization levels the...

Here's an alternative as well for table space usage that is very detailed.

http://jasonbrimhall.info/2014/03/28/table-space-updated-again/

S_Kumar_S (4/23/2014)

---

Can i change the data type from ntext to nvarchar(max) and then will I be able to rebuild the index online?

Is there any other way around to rebuild it...

periwinkle

GilaMonster (4/23/2014)

---

Brent Ozar (4/23/2014)

---

A lot of the fun of the MCM lab was that the questions had surprising catches. The questions and answers alone weren't enough - the lab environment...