Same way as for the clustered index or heap

SELECT t.name AS TableName, i.name AS IndexName, p.data_compression_desc

FROM sys.tables AS t

INNER JOIN sys.indexes AS i ON t.object_id = i.object_id

INNER...

Koen Verbeeck (2/6/2012)

---

Cadavre (2/6/2012)

---

Tried polite and unpolite impolite comments directed at him, neither received a...

The first thing that you...

There's only really one way.

When there is no portion of the active log in the file you want to remove, you can just ALTER DATABASE ... REMOVE FILE.

DBCC loginfo...

Also make sure that you have support from management before kicking people out, otherwise those internal users will go to management and complain that you are preventing them from doing...

Is there an IT security policy (or other policy) in place that prohibits what they are doing? If not, the first thing to do would be to get management approval...

Damian-167372 (2/6/2012)

---

GilaMonster (2/6/2012)

---

That's what I was saying....

Btw, I've been through this, had a couple devs who knew the app's password and thought they were above the rules. I put a...

That's what I was saying....

Btw, I've been through this, had a couple devs who knew the app's password and thought they were above the rules. I put a login trigger...

Oh, one other added complexity - Maintenance plans have an app name of Microsoft SQL Server Management Studio..., so be careful you don't throw your maint plans out (I found...

Yes, DBCC DBREINDEX and no, the database does not need to be taken offline (and if you mean the database state OFFLINE, reindex won't be able to run). That said,...

Nothing wrong with login triggers, however a few things to consider...

You block connections from SSMS, now, what about Query Analyser? isql? osql? sqlcmd? Access? Excel? 3rd party tools like Toad?...

Rebuild the clustered index. See if that fixes things.

Does the table have a LOB column?

The only real lambasting I gave was the SVVM thread, and that would have been given with or without the thread (in fact was before i dropped by the thread...

Dev (2/6/2012)

---

Per BOL:

CXPACKET

Occurs when trying to synchronize the query processor exchange iterator. You may consider lowering the degree of parallelism if contention on this wait type becomes a...

Already done days back. No reply and no improvement.