while its true that with RAID10 a failure of a mirrored pair is terminal. Because of the amount of disks required for RAID10 its a sort of safety in numbers...

is it absolutely necessary that node 3 has 4 instances of SQL. This will affect the RAM configuration on that node

kendal.vandyke (12/28/2008)

---

Perry Whittle (12/28/2008)

---

as you say, depends if the system is already live. If...

try the following query

select @@servername, serverproperty('servername')

what is the result

as you say, depends if the system is already live. If your scoping new...

best way!

run a server side trace and dump the output into a sql table

truncating the log will remove any inactive entries but not reduce the actual physical file size.

shrinking the log will reduce the physical file size,

but it's worth noting you cannot...

if the browser is running it does yes

i seem to remember, initial contact is made over 1433 then the server passes back the details of the named instance(s) and its ports\IP address

Vista users run as low privelege normally, what does sql authentication produce running the same statement?

Lynn Pettis (12/17/2008)

---

since it needs to create the table on the fly it doesn't know how big the column needs to be so it so it makes it the maximum...

from where exactly?

at the end of the day this is exactly what clustering is designed to protect against so yes its the best way. Fail...

just be sure not to tick the "relay messages to all domains" check box otherwise after a couple of hours your public ip address will be blocked 😉

not at all.

RAID 10 will generally offer a performance boost over RAID1 due to the striping across mirrored sets. As SQL server writes to...