Kurt W. Zimmerman (10/7/2013)

---

Grant Fritchey (10/7/2013)

---

Don't manually restore the database.

Create a script that restores the database and make the procedures you need part of the script (after the restore of...

This question was asked in more than one forum. Please put all further responses on this post since two of us have already responded over there.

Wait, didn't you already ask this question on another forum here at SQL Server Central?

Please don't do that. It leads to multiple answers and confusion across the discussions. As you...

Don't manually restore the database.

Create a script that restores the database and make the procedures you need part of the script (after the restore of course). You can then schedule...

You're going to need to be more specific.

SQL Server comes with a process called SQL Agent which is used for scheduling jobs, setting up alerts and other things. That is...

The role of the DBA is generally considered somewhat vital to the organizations that hire one. So, in general, they don't hire people with zero experience. There are exceptions to...

Jack Corbett (10/7/2013)

---

In some parts of...

Yep. This site is very good. You can also look to ask.sqlservercentral.com for simple question/answer style of issues. You can also look to Simple-Talk.com to for in-depth articles.

What about just putting the create procedure scripts into the same set of commands that restore the database. Assuming you're using SQL Agent to automate the execution of the restores,...

2gb is a VERY small amount of memory for SQL Server. How much data are you trying to retrieve? How big is the query? The message you're receiving is very...

Backups and restores.

Oh, those weren't on the list. I'm going to support Gail's answer. If you spend more time building and designing systems, having a working knowledge of how the...

Excellent editorial Steve.

At my previous employer we spent years and interviewed hundreds of people trying to find qualified DBAs. This story, someone knows a few things and repeats them for...

What Gail said.

But, if you really want to avoid adding too much additional overhead to the system, then instead of a trace, I'd look at extended events. They're much more...

I would not suggest turning it off, no. You can add additional traces if you need them, but the default trace captures a basic set of information about what's happening...

I would suggest focusing first on wait stats to understand what is causing the server to run slow. But, if you want to know if you're out of memory, going...