It's been in Sept before, a few times, and once in Jan when the Sept one was cancelled because of a hurricane.

When it's in Seattle, it's usually Nov because of...

Sept 2, check. Ready and waiting. A whole new strategy this year to try and not sweep up the basement.

Wow, 4,000.

http://espn.go.com/new-york/mlb/story/_/id/9589905/ichiro-suzuki-new-york-yankees-gets-4000th-professional-hit

I am so rooting for him to make 3k in MLB.

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.