Viewing 15 posts - 76 through 90 (of 491 total)
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
June 21, 2011 at 12:01 am
1) Does all the features that were provided by Sql server 2000 will be suppported by Sql Serve 2008?
Full support of legacy applications
2) Which version Standard/Enterprise of Sql server 2008...
June 20, 2011 at 11:57 pm
I think there is no need of more memory in the case of Direct Cache
June 20, 2011 at 11:54 pm
Use failover Server in the connection string of an application
June 20, 2011 at 1:12 am
Does my choice for a 'Node and Disk Majority' quorum based on a two node cluster and my explination above a logical one?
Yes
June 20, 2011 at 1:10 am
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...
June 18, 2011 at 1:24 am
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...
June 17, 2011 at 12:29 am
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...
June 16, 2011 at 12:16 am
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...
June 16, 2011 at 12:01 am
Another option is
Administrative Tool - > Services - > SQL Server
Administrative Tool - > Services - > SQL Server Agent
Administrative Tool - > Services - > SQL Server Analysis...
June 15, 2011 at 11:56 pm
How many nodes will be there ?
Distance Between Multi Site ?
June 15, 2011 at 11:46 pm
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...
June 14, 2011 at 10:00 am
I will suggest you to recreate those indexes after applied the partitioning
June 14, 2011 at 9:53 am
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
June 14, 2011 at 6:12 am
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...
June 14, 2011 at 4:21 am
Viewing 15 posts - 76 through 90 (of 491 total)