Processors and RAM in this server ?

Use Raid 1 for Tempdb

Use Raid 5 drive D: for Log Files

Use Raid 5 drive E: for mdf.ndf Files

total space is dependent on the...

Partition the table first then Indexes,performance will be increase if table have heavy DML operation and huge data in the table but dont forget to define the Lock Escalation to...

you can do shrink the database in only 1 special circumstance when only 1 door is open ,you are completely lost with space and there is no any other option...

Give other users Readonly rights and then try to take the full backup and then restore it with different name after restore is complete then drop the previous one and...

Osql is depreciated in SQL Server 2008 ,you can use SQLCMD but SQL server is not running how he can pass statement against the instance.you should check or input the...

There are 2 types of Compression in SQL Server

1-Row Compression

2-Page Compression(Row Compression + Prefix Compression + Dictionary Compression)

Performance will be decrease because when you retrieve the compressed data...

When a Core is busy on a file of a filegroup then a second core can access the second file of a filegroup , that is not related only the...

Go to First Node and then ping the second node with the NIC connect directly for the heart beat and then do the same for second Node to the first...

Check the LSN number of Transaction Log Backup File,you can check also this LSN information from backupset in the msdb database

then verify this back_set_id in the msdb restoreFilehistory table on...

If you are going to install a second instance of SQL Server you should have enough hardware capability to manage this second instance like Processors Core,RAM and Separate Disk for...

he want to take backup of Master database of Mirror server ,doesnt want to mirror the master database

First check the Execution Plan of the particular SP ,where is the cost

this account is powerfull and highest level of privileges on the local system,if you have revoked the Built-In\Administrator sysadmin rights then you have to give these rights to this account,by...

I didnt say Active\Active is not possible but as requirement of @anthony-2 is distribute the load of 1 instance on multple nodes that is not possible in SQL Server Environment,Yes...

for DR side I recommend database Mirroring ,how much data loss you can bare