Search Results | SQL Server Performance Forums

grouping data

Post by: vikasrana_dba, Jan 28, 2010 in forum: SQL Server 2005 General DBA Questions

As Preethiviraj said Itâ€™s really a very good example with very good explanation

Proper Index

Post by: vikasrana_dba, Oct 22, 2009 in forum: Performance Tuning for DBAs

Hi Ravi, As Atul already said you can not create index for every query type But if I go according to your question then yes you have to create one...

Proper Index

Post by: vikasrana_dba, Oct 20, 2009 in forum: Performance Tuning for DBAs

Hi Ravi While creating composite index on Department and Location column likeCreate clustered index CI_table on table(department,location)in this...

Undo Transactions

Post by: vikasrana_dba, Apr 10, 2009 in forum: SQL Server 2005 General DBA Questions

Yes you can use third party Red Gate Software SQL Log Rescue to UNDO already committed transaction.SQL Log Rescue is compatible with SQL Server...

Firewall

Post by: vikasrana_dba, Apr 9, 2009 in forum: SQL Server 2005 Log Shipping

1) On Secondary Server firewall, open port 1433 so that primary server can connect to it. 2) Make sure File Sharing is enabled on the local...

Performance Problem

Post by: vikasrana_dba, Apr 9, 2009 in forum: SQL Server 2008 Performance Tuning for DBAs

Thanks Satyaâ€¦ You are correct running DBCC DROPCLEANBUFFERS will drop the entire buffer which will decrease the buffer cache hit ratio and...

Performance Problem

Post by: vikasrana_dba, Apr 7, 2009 in forum: SQL Server 2008 Performance Tuning for DBAs

Please run the use database_namegocheckpointgodbcc dropcleanbuffers and then test the a & b user performance again. I don't think this issue related...