Here is a good place to start if you haven't already.

http://msdn.microsoft.com/en-us/library/ms189134.aspx

Wilfred van Dijk (11/19/2008)

---

You probably mentioned the "... a significant amout of memory has been paged out ..." errors you'll see in the errorlog.

The solution is simple:

1) make sure the...

You can it isn't recommended, I'll post some links for clustering. I've ran into that same problem a year ago.

Jason Williams (10/9/2008)

---

As our SQL server environment continues to grow, we are starting to look at 3rd party backup solutions. The two I keep seeing are:

Red Gate SQL backup

and

Quest Lite...

Also forgot to ask is this a single proc server or a quad ect? Only reason i ask SQL server has a problem if Mdop is set to use all...

That query is mainly to check to see if there are any memory problems.

This query is will show in detail the query plan in the xml field click on the...

Niyala (11/3/2008)

---

Hi, all,

I installed MS SQL server 2005 on windows 2008. The installation went smoothly except for minor complaints of Visual Studio.

After installation, I did basic configurations and all was...

balbirsinghsodhi (10/31/2008)

---

I am really fed up with one of the query which is taking forever. i could not figure out the issue. I have checked the indexes and all the...

Niyala (10/31/2008)

---

Hi,

I tried to install sql server 2005 on windows server 2008, but my first trial failed. From your message, I understand that you managed to run sql server 2005...

bodhilove (10/1/2008)

---

Hi Folks,

What maintenance should be done on a mirror database on a regular basis.. which would mean failover. For example.. is database defragmentation needed? Also is it ok...

Actually that does help out, Thanks

http://www.sqlservercentral.com/articles/Administration/2605/

hehe not really, its more like we are moving to it regardless, I am just trying to find anything about 64 bit that isn't supported like it is in 32...

I just tested linked servers 32 bit to 64 and 64 to 32 bit and they work.

DTSRun isn't support on a 64 bit platform according to a few blogs, but...

we have a 3tb oltp db and a few smaller ones roughly ranging from 100gb to 400gb

we are using mount points for clustering due to the fact using file groups...