Jeff Moden (3/16/2011)

---

Craig Farrell (3/16/2011)

---

Isn't that like saying you're a 'nice' barbarian because you only...

Yes and no. DBCC is subject to contention issues the same as almost any other process. Assuming no connections and no activity, yes, I'd expect it to run more or...

BTW, Gail lives in South Africa which is about 6 hours ahead of us. It's near midnight her time. She's up this late sometimes, but sometimes not. Just so...

Are you looking for sys.dm_db_index_physical_stats?

A query would look something like this:

SELECT * FROM sys.dm_db_index_physical_stats(DB_ID('AdventureWorks2008R2'),object_id('person.address'),NULL,NULL,'sampled') AS ddips

No, you really can't do that. You're going to have to get to that user and train them or get ahold of their code and clean it up. Either way,...

Did a few tests and this seemed to work just fine:

EXEC sys.sp_renamedb @dbname = [MyDB ], -- sysname

@newname = [MyDB2] -- sysname

;

EXEC sys.sp_renamedb @dbname = [MyDB2],...

GSquared (3/16/2011)

---

GilaMonster (3/16/2011)

---

CirquedeSQLeil (3/16/2011)

---

GilaMonster (3/15/2011)

---

WayneS (3/15/2011)

---

Now I really want to see it! Good job on insulting any and all... sounds like Jeff and his pork chop launcher might be rubbing...

Brandie Tarvin (3/16/2011)

---

There are a lot third party tools for sale that will monitor multiple servers, also. I believe both Imceda and Red Gate have software, along with several other...

Unless you want to look at SQL Server 2008 R2 multi-server management, you're just going to have to set up a lot of manual processes out to multple servers. No...

Here's some info on the default trace.

It sounds like you're getting spikes on usage. That can be normal. A particularly nasty query used the CPU a lot and then cleared. The problem with setting a threshold...

Another way that sometimes works is to eliminate the OR by rewriting the query to use UNION ALL and then putting each side of the OR clause on either side...

Reorg is specifically for indexes that are only lightly fragmented as a way to give them an augmented performance metric at very low cost. You're looking 90% fragmentation. you need...

GilaMonster (3/15/2011)

---

Awesome. Great fun. Timing went perfectly too (for once)

Trying to figure if I managed...

I'd say Nivek summed it up fairly well there.