Performance can be effect and its depends on the Processor physical or logical ,RAM and Storage controller

Operating System Version ?

Total Processors Logical and Physical ?

Total RAM ?

Hardware Numa total...

check Database Audit Specification

http://msdn.microsoft.com/en-us/library/cc280472.aspx

http://msdn.microsoft.com/en-us/library/cc280404.aspx

EVENT DATA()

http://msdn.microsoft.com/en-us/library/ms173781.aspx

http://msdn.microsoft.com/en-us/library/ms187909.aspx

http://www.microsoft.com/sqlserver/en/us/product-info/compare.aspx

check this link for maximum RAM support for Standard Edition

yes its stable ,CU# 7 and Service Pack 1 is available for R2,I dont think so its worth upon sql server 2008 but there might be some features benefits

any authentication about this flag

-T8015

yourserver\instancename,port

check the second instance port

Default port is 1433 for default instance and 1434 is for browser service default service,change the second instance port restart the service and then try to...

1-Take Full backup and then restore on the physical server with no recovery(no downtime)

2-Down your application (Down time started)

3-Take differential backup (differential backup time depends on the change in database)

4-Restore...

select object_definition(object_id),name from sys.all_objects

where type = 'TR' and object_definition(object_id) like '%your table name%'

you have to create a table of tables list which those you have dropped then create a loop...

Windows Server 2003 32-bit/64-bit ?

Recent Updates for the OS ?

SQL Server 2005 SP4 ?

SQL Server 2005 32-bit / 64-bit ?

Windows Server 2008 R2 32-bit/64-bit ?

Recent Updates for the OS ?

SQL...

RAC is session persistence then user will not interrupt when node move,RAC is also for ACTIVE/ACTIVE which means real load balancing 2 or more Servers point to the same Oracle...

1-Qorum

1-MSDTC

1-SQL Server Instance One Resource Group,it have own disk

1-SQL Server Instance Second Resource Group,it have own disk

More than 1 instance on more than 1 node cluster,you can define same resource...

1-Take Full Backup of the required database and system databases also first if possible otherwise take different backup at least of user database

2-Rebuild or ReOrg indexes depends on the avg_fragment_percent...

paste the actual or execution plan of that query

because your covering index does nt meet the requirement of the optimizer

Paste or attach the Actual or Execution plan of that query

Square bracket define when name of the object is like

1-jahanzaib is not need to define brackets

2-[jahan-zaib] is need to define in backet