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

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.