GilaMonster (12/9/2011)

---

You are, I assume, aware that shrinking TempDB without completely and totally quiescing the server can cause corruption that will require a restart to fix?

Ninja's_RGR'us (12/9/2011)

---

Obvserving is usually silent & internal ;-).

Commentating and giving useful output is another beast altogether. :Whistling:

Dev (12/9/2011)

---

crookj (12/9/2011)

---

WOTD - Recursive

Loop

GilaMonster (12/9/2011)

---

Ninja's_RGR'us (12/9/2011)

---

SELECT * FROM #t WHERE a = 1 AND b = 2 AND c = 3

--Ix Seek

Seek and secondary filter. It can't just seek.

DBCC SHRINKFILE: Page 1:378832 could not be moved because it is a work table page.

Ninja's_RGR'us (12/9/2011)

---

Nothing to do with luck.

And do you not read what we post on purpose or you just like to post?

chauchs (12/9/2011)

---

Arfff !!! :doze:

Thx, but this is not the answer that I was hoping

Does the value after the '_' represents something (in the name in tempdb.sys.objects)

chauchs (12/9/2011)

---

Hello,

is there a solution to know the spid (or other) who own a # table in tempdb.

Thx

prashant-507002 (12/9/2011)

---

I think there are some hidden command in sql server which Microsoft not make it public.

Can any body know the powershell command?

prashant-507002 (12/9/2011)

---

I think i have to post support ticket to microsoft for the same.

prashant-507002 (12/9/2011)

---

I think i have to post support ticket to microsoft for the same.