Could you be a little more specific as to what you're looking for?

That query will do part of the work. It'll pick up table scans only on tables that don't have a clustered index, i.e. heaps. For tables that do have a...

The database was in simple or bulk-logged recovery model.

Probably more than 150. 200 or 250 to be safe.

Filters out rows in the statement text that have object IDs and database IDs, ie...

Union all usually one of the most efficient ways of concatenating result sets. The alternative to LEFT functions is usually to not use the function at all.

Got a shrink operation running, automatic or manual?

You can do that, in any version of SQL. If you do it and then try to restore logs you'll get an LSN mismatch error and the restore will fail.

Once...

Same as any other database, roll forward then roll back. With a log shipped database the roll back portion is only done when recovering the database, the roll forward is...

nm

Ignore the file modification dates for SQL Server database files. They're not updated every single time a change is made to the DB, that would be useless overhead.

It still has a different top, different where, different select list and a different order to the OP's queries.

Boris, try this, it should be a combination of your two. I...

Post the procedure. It probably just needs a small tweak and not any temp tables.

You might want to edit that query, as it has filters and sorting that was no where in either of the queries the OP posted. It's a query on those...

basavarajyn (6/13/2013)

---

When I ran Database Engine Tuning Advisor, it suggests to create a non-clustered index on the column where a clustered index is already present.

Can somebody give me some...