Reducing the logical reads involves tuning indexes and query. That's about all that can be said without further information.

See Chapter 4 of http://www.red-gate.com/community/books/accidental-dba for a lot of discussion of memory and some guidelines around the setting of this value.

The setting takes effect immediately, no restart is required.

rodjkidd (2/19/2014)

Jason, not sure about...

A Full database backup is just that, a backup of the full database, all data files.

When restoring, unless you need to move the files to a new location it's...

Welcome to page 2150 🙂

It's not necessarily the easy questions that we moan about. It's the ones with no thought or no research or the ones that are unreadable or...

Can you run a select on the table, get the DATA_LENGTH of each of the lob columns and order by the sum of all those columns data lengths desc? Let's...

Are all the distincts really necessary? Is the Union necessary or will union all work?

Personally I prefer creating clustered index on a temp table before putting data into it...

Though not without analysis first including some work to ensure TempDB can handle the additional load.

Firstly, is the cost a problem? Large is not necessarily a problem as the percentages within a plan have to add to 100%

You'll never see a key lookup caused by...

From Books Online (under ALTER INDEX)

Table locks are applied for the duration of the index operation. An offline index operation that creates, rebuilds, or drops a clustered, spatial, or XML...

Ooh, that's a lot of LOB columns.

Maybe an index reorganise with LOB_Compaction on?

RowLock takes locks at the row level. It won't prevent lock escalation, but it will start the locks at the row level.

The table is a heap?

You can set them after installation, not during. They're both database level settings.

to be honest, I don't see much point in having them both on, usually one would pick one...

A candidate who described himself as a database performance and recovery specialist.

Me: You get alerts that a critical database is not available and when you look in Management Studio you...