When I'm teaching reading execution plans, my favorite moment is when I show a delete query which then hits 15 tables doing RI lookups and I ask people, "So, still...

I think you're already doing the right thing, adding indexes to support the lookups required for referential integrity. The only other thing you could do is drop the RI while...

jcrawf02 (12/16/2011)

---

By the way, if anyone feels so inclined, prayers and happy thoughts would be appreciated for my family today. No more info at the moment, I might share in...

Threadizens!

Anyone have a script that will reliably generate a deadlock from a single process? I need to be able to repeatedly generate a parallelism deadlock for some internal testing. I...

Don't be surprised when those values constantly read almost exactly the same. Some counters that are going to change that will show you how things are behaving would include:

memory:pages/sec, page...

You don't want your average business person mucking about in your database. First thing is to have something in front of it to make it easy for those people.

Next, the...

You have to define fake. Is fake being that you don't know everything about everything? Yes, we're all fake. Is...

Cleaning up unused indexes is an OK use for your time, but, you need to be aware, sys.dm_db_index_usage_stats only records information since the last time the server was restarted (and...

Your approach is basically sound, yes. Be sure that two hours is how much data the business is prepared to lose in the event of a catastrophic issue. Also, test...

RSP (12/14/2011)

---

Thanks, Grant! This makes sense, and no I don't consider you a goof from the internet, as the previous poster suggested 😉

<<Maybe that index will save you tons...

LOB's? No, that index doesn't make that much sense.

There are a couple of fundamental problems with missing index recommendations. First, they're based on the stats available to them, so if...

If you do need to set up a custom set of monitors to keep track of changes long term, instead of relying on the default trace or using your own...

Page life expectancy is a constantly changing measure. You can't take a reading once and have some idea for how it's behaving. Same goes for most of the monitored values....

Things like this:

CONVERT(DATE,LR.FromDate) BETWEEN CONVERT(DATE,@FromDate) AND CONVERT(DATE,@ToDate)

Are going to cause major performance headaches because indexes, if you have any, won't be used to find the data in LR.FromDate. Instead...

Oracle is just a whole different world with a different set of capabilities and problems. If you don't know Oracle now, time to learn. You're going to have to change...