High CPU or high memory? High memory is normal and good, it's not a problem.

High CPU, see chapter 3 of http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/

also

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

Nolock applies just to the table that it's specified on, and it will override the default isolation level as well as any requested with SET TRANSACTION ISOLATION LEVEL

Two backup jobs.

If you are running differentials that second one...

Nadrek (11/21/2012)

---

P.P.S. Gail, I don't work with the OP, but I have worked with servers which have more than enough RAM (100GB+) to allocate 35GB to a single query and...

And the error log....

And which drive filled? You initially said the log, now you say the data?

What files exactly did you delete?

First thing to do, before trying random stuff, would be to identify the specific cause of the DB not being able to be opened.

What does the errorlog say? (it'll say...

Many ways. Try the SSIS transfer logins and transfer jobs tasks.

How can you overcome what? What exactly is the problem?

dnonyane (11/21/2012)

---

Hi Guys thanks for the advice,i think i will have to hide the data in a temp db as people never open that database and work with it from...

dnonyane (11/21/2012)

---

We wanna create security such that this database can only be accessed be people who are added under users not everyone who is added in the sql server.it must...

lovinginmyheart (11/20/2012)

---

2. with query tbl1 inner join tbl1_detail in month 1, will the SQL work in parallel by querying data in drive 1 and drive 4 in the same...

Sure you can, if you know that space won't be used in a reasonable amount of time.

A once-off shrink and then rebuild all your indexes afterwards.

PhilipC (11/20/2012)

---

Currently, I have the following query I'm running across multiple SQL Servers to get some basic stats.

At the moment, I'm using a new with "serveradmin" permission in order to...

matt.bowler (11/20/2012)

---

Okay - I'm assuming that you don't have a recent backup here - because that would be the best option. Short of that you need to do a bit...