It's not necessarily memory, and physical memory doesn't matter all the time. SQL Server has its own memory management and limits.

Perhaps you could start from the beginning and explain how...

You are pulling back 6GB of data. If you're doing this in a client, you might have rendering issues, as well as IO/memory issues on the server. 6GB of data...

DBCC CHECKDB on every database at least every month if you can't do it every week or every day.

Craig-315134 (8/21/2013)

---

The author wrote:

... I sometimes think that an investment in developer education would quickly erase any productivity losses ...

Education is always a good thing, but it applies all around,...

It's too much for me to write about. Basically a trace that's running and rolling over all the time. You can search for more info and read about it.

http://www.sqlservercentral.com/articles/64547/

I'd agree training can be important and Brent is great. Relatively few hours with his company might save you a lot of headaches later and teach you some things.

In terms...

Was this database upgraded from an earlier version?

I'd think that a net stop would be an expected shutdown. It could be some driver in Windows that is is not shutting down cleanly, and one that SQL Server...

There is the default trace, which gives some information, but if you are looking for some storage history of who modified which objects, this isn't really tracked by SQL Server.

No idea. I use Firefox most of the time on my desktop. I'd guess it has some security setting, but no idea.

Jim P. (8/20/2013)

---

There is one configuration change that I always make immediately after I install SQL Server, and advise everyone else to do too. That is turn off Named Pipes....

Restore. That's how you create an identical server. It's also how you practice DR.

You can't have the same name on the network because of Windows restrictions.

If you want to set up a DR type server you can bring online, then you should restore...

You need schemas. Otherwise how are objects structured? You need roles, in that security should be tested. If you want different security in UAT, then have a script to set...

Do they have the largest stake? Or are they just the largest user? The item they request might not even be in use in the majority of their systems.

This is...