Hello beejug1983,

2 GB is very tiny one. nowadays the home system default memory configuration is 4 gb. And still you using...

Lutz great reply.

beejug1983 (11/28/2011)

---

Hi,

I have a server of Windows Server 2003 R2 SP2 with 2 GB of RAM, In task manager more than 1 GB of RAM always shows for SQLServer.exe.

Is this...

Post the maintenance plan history error.

Perry,

Yep there is lots of options available. still Everything is "It depends".

@meridius10 search here Jonathan's post 'Alter database method' and read it.

Then tell that third party software vendors to remove that option.

You have asked something related about memory as your first post...

meridius10 (10/21/2011)

---

I have reinstalled my OS, as well as using the instructions in the video to detach/attach the db, and this appears to have been a relatively straightforward process using...

Have you seen the CUP 100% always?

How about fragmentation?

There is lots of thing out there the CPU went high % run a server side trace and find the things. Also...

How big the DB?

paul.knibbs,

I love to use t-sql as always. And the easiest way is t-sql.

Have a look

http://www.sqlservercentral.com/articles/Best+Practices/61537/

Have a look: Link from paul

http://sqlskills.com/BLOGS/PAUL/post/Search-Engine-QA-19-Misconceptions-around-index-rebuilds-(allocation-BULK_LOGGED-mode-locking).aspx

True,...

Hi sachin,

Post me the correct and full script.