Check out this : - https://ola.hallengren.com/

Anyone would like to share the access code to download the exam questions from pass-guranteed.com?

“Sit for exam 70-432” is on my to-do-list for the last 12 months. Your article has now directly influenced to complete the task on 9th Sep 2011 – almost a...

I am consolidating our medium and small databases on VMWare servers.

Can someone explain the advantages of using NeNetAPPanager for SQL ?

What are the benefits compared to the...

Many people said I will not habe 1+0 (or 10) with jusy only 2 disks.

This my network guy's suggestions, but I will see other alternatives.

FOr SQL data, logs, tempDB,...

Question on CAL licences again ?

If we have 3 users accessing the SQL server using an third party application, do we calculate 3 or 1 CAL ?

More clearly, lets say,...

Maximum we have 1500 users, might use 2/3 applications connecting to different DBs on the same SQL server.

We have 20 SQL 2000 and 5 SQL 2005 licences per processors...

Do you have SAN attached to the Box. What other considerations need when you setup the box ?

Whats is the price difference between standrd and Enterprise ?

How did you arrange...

http://www.microsoft.com/sql/editions/enterprise/comparison.mspx

says the Standard only supports 4 CPU

We have 2XQUAD processors. Do we go for SQL 2005 standard or Enterprise ?

I know SQL 2005 standard will support OS (Windoiws Ent with 12GB) max memory, but will...

I found the following recommendation for hard disk configuration from

http://www.mssqltips.com/tip.asp?tip=1328

But, unable to figure out the suitable configuration for me.

As I mention before we got 2...

Thank god for that

I was exactly planning for multiple instances. Now probably install all on single instance.

The HW we purchased supprts 64bit. I am definetely insalling 64 bit SQL2005.

But, anyone advice on Windows (64 bit) version standard or Enterprise ?

How can I configure...

you are absolutely correct. The apps see only the listening SQL version, not the architecture it is running on.

Anyway, I just got the confirmation from you as a proof.

Thanks

The apps are IIS based intranet pages or, third party SW purchased from SW vendors.

Example Bighand Workflow Server, Enterprise Vault Services or http://www.hrpro-online.com/ etc