SQL Server Configuration Questions and Answers

Recent IT Questions

1 - 3 of 3
<<PREVIOUS 1 NEXT>>

Implementing indexed views on a SQL Server

How can I implement indexed views on our SQL Server? Is there an example that shows how they would improve query performance?

asked by SQL Server Ask the Experts

  2445 pts.

How do I configure SQL 2005 to use 22GB RAM on a Server with 24 GB RAM running Windows 2003 EE ?

We have Windows 2003 Enterprise Edition (32bit) running on a IBM Quad Core Xeon Dual processor system with 24 GB RAM. The same server runs SQL 2005 with SP2. How do I configure SQL Server to use the maximum RAM say upto 22GB RAM ?

asked by Ravikswamy

  20 pts.

Deciding on configurations for SQL Servers

My new server has 3 x 146GB SAS 15k 3.5" HD, which came pre-configured as RAID 5, and 2x 73GB SAS 15k 3.5" HD, which came as RAID 1. Should I leave this configuration as is or should I change it?

View Answer   |  Jul 31 2008  6:10 PM GMT
Servers, RAID, RAID 1 vs RAID 5
asked by SQL Server Ask the Experts

  2445 pts.

1 - 3 of 3
<<PREVIOUS 1 NEXT>>