any type of database restore event on any database in an instance will clear the proc cache, this is what you are seeing.

This is intended behavior. you should also see...

because SQL...

ckanow (10/22/2009)

---

TS-terminal services, the server is underused - so we decided that we'd run sql on it, not being able to buy even a baby machine just running sql.

MS...

still not quite sure what you are trying to do, What's a TS server?

you cannot store the databases on a different server to the SQL install. what you could do...

would have to ask what you are trying to achieve? Physically moving system database files to another server is not a common way of migrating data.

If you really want to...

BOL actually describes this process.

use alter database ...modify file syntax.

stop\start SQL

delete tempdb log file in old location

ALTER USER Smith WITH NAME = Jones

yep, totally shameless. 😀

How much do I have to get my boss to spend to save me typing sp_help or expand object explorer?

(p.s I don't spend all day cutting code...

Silverfox (10/19/2009)

---

If the other site is going to be a success/failure, let it do it on its own merits without trying to gain support by linking it to the main...

getting people to use the ASK site for purely deterministic and therefore presumably simpler questions seems a good way to go although how you get people to do that I...

From a purely DBA point of view where you are going to be querying system tables, DMVs etc it would be very annoying when troubleshooting under pressure not to...

just going back to this that is a high fragmentation percentage.

7 tables out of how many? What size...

have a good read of this blog:

http://blogs.msdn.com/psssql/archive/2009/09/11/fun-with-locked-pages-awe-task-manager-and-the-working-set.aspx

go to google - type 'sql server memory requirements'

I am not quite sure why you have started this other site, are you not going into competition with yourselves? seems to me there is a danger of diluting this...