Set Nocount

when you set on this,SQL Server will not count the rows ,it will increase the performance because overhead of counting must be disabled and another overhead is print

Full support of legacy applications

2) Which version Standard/Enterprise of Sql server 2008...

I think there is no need of more memory in the case of Direct Cache

Use failover Server in the connection string of an application

Yes

multiple data files as well as multiple log files give you benefits on loaded servers

you check the Delays milisecond with the help of this query

select DB_NAME(database_id) DB_NAME, di.file_id,df.name,io_stall_read_ms ,num_of_reads

,cast(io_stall_read_ms/(1.0+num_of_reads) as...

G Drive is a cluster drive or not ?

Have you added this drive in the Cluster Storage ?

Have you created first SQL Server group and then start installation or you...

If this occur on the front end then you should have an application log trail table in the database design and if this occur on the back end then restrict...

what is the name of Instance or you have installed Default Instance ?

Can you connect SSMS (SQL Server Management Studio) on the same server ?

Are you using IP or Domain...

Another option is

Administrative Tool - > Services - > SQL Server

Administrative Tool - > Services - > SQL Server Agent

Administrative Tool - > Services - > SQL Server Analysis...

How many nodes will be there ?

Distance Between Multi Site ?

Processor have 4 Cores and 8 Thread and 2.4G its a good one,yes you can move later as per requirement if you see locks and performance issues then come to...

I will suggest you to recreate those indexes after applied the partitioning

gets the data first on the SQL Server side and then apply join on it, means insert data in a temp table then apply join

I assumed that you have created all objects in SQL Server now you can use Linked Server in SQL Server and Database Link in Oracle to communicate these RDBMS each...