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...

Lots of key lookup operations. I'd be concerned that my clustered indexes are not useful. And that SORT operator is the main cost currently. See if you can modify that...

ashanair70 (12/12/2011)

---

We create test database from a backup copy of production database every weekend. I want to find out whether there is a way I can find the last refresh/restore...

And after copying the files use ATTACH to get the database set up on the new server.

And there is the problem with the DTA in a nutshell. How important are the suggestions it has, not even worrying about whether or not those suggestions are helpful.

Unfortunately, you...

What do you mean by "refresh"? There's not a command or process that specifically defines this, so you could be referring to a lot of different things.

Looking at the query, we're really going about it the hard way. A little searching brought up this, and Isaac Kunen's solution. Try that instead.

Nuts. I wasn't paying attention... again...

Yeah, 2008 is problematic. They fixed stuff in R2. If you're doing spatial, you really need to move. That's the only good solution. Sorry.

Hmmm.... I'd try low too. The density stuff seems counter-intuitive sometimes.

Do you have an index in place? If so, start messing with the density on the index. I found that changing[/url] that has interesting impact. The key to the density...

Hmmm... I'm stumped. I'm not sure why that TOP is in there. But, I don't know that I'd sweat it at the moment with all those clustered index scans to...