Our friend of the vague questions.

Potentially a very expensive setting. In terms of money, not server performance. 🙂

I'm assuming that you didn't bother to read the two links...

Only when you run the query that references the view.

I'd watch out for the AI mode personally. It's pretty experimental and who knows what will happen if you give your server autonomy.

Page verify checksum.

Pro: If the IO subsystem messes up and corrupts a SQL page, any read of that page will pick it up immediately. Since the checksum is the...

You have noticed that you're answering a 3 year old thread?

Views don't store results. They're simply saved select statements that SQL unrolls into the query when they are referenced.

TempDB is used for Temp tables, table variables, internal work tables (resulting...

If you mean the "Lock pages in memory" local security policy setting, then these may be of use

http://msdn.microsoft.com/en-us/library/ms187499.aspx

http://msdn.microsoft.com/en-us/library/aa198229%28SQL.80%29.aspx

If I turn on, it...

exec sp_configure 'Run SQL Faster',1

I've actually given that to...

Hmm, I interpreted this as the security setting 'Lock pages...

Grant Fritchey (12/9/2009)

---

Bru Medishetty (12/8/2009)

---

Lynn Pettis (12/8/2009)

---

If you can't find one, start one. There are several people on this site that have done so, and I'm sure they would...

Anyone's telepathy working well at the moment? http://www.sqlservercentral.com/Forums/Topic830993-5-1.aspx

steveb. (12/9/2009)

---

This will not repair anything, it simply scans the database for physical structure errors and is a lot quicker to run that a full scan does a lot...

Why do you want to avoid having it? Your questions are very vague. What is the problem?