Search Results | SQL Server Performance Forums

what is compatibility level in sql server?

Thread by: sqldbarocks, Jan 22, 2011, 11 replies, in forum: Getting Started

what is compatibility ?is that between databases/servers?

when to use merge,transactional replication

Thread by: sqldbarocks, Jan 22, 2011, 2 replies, in forum: SQL Server 2008 Replication

when to use merge,transactional replication

Removing replication insqlserver 2008

Thread by: sqldbarocks, Jan 22, 2011, 1 replies, in forum: SQL Server 2008 Replication

how do i remove replication setup in 2008

replication,security,logshipping,performance interview questions

Thread by: sqldbarocks, Jan 22, 2011, 3 replies, in forum: Getting Started

Answer the following: it may helpful to newbies who wants their career as a dba Sql dba freqently asked questions in interviews: what are the...

what is purpose of dbcc update statistics in performance tuning?

Thread by: sqldbarocks, Jan 22, 2011, 2 replies, in forum: SQL Server 2008 General DBA Questions

Hi does any one having any idea about dbccupdate statistics purpose in performance tuning?

monitoring cpu,memory,I/O usage with profiler

Thread by: sqldbarocks, Jan 17, 2011, 4 replies, in forum: SQL Server 2005 Performance Tuning for DBAs

Hi Can some one pls help me in adding events and resolving CPU,Memory,I/O bottlenecks in sql server profiler ....is there any way to handle them in...

resolving blocking issues as a dba

Thread by: sqldbarocks, Jan 13, 2011, 3 replies, in forum: SQL Server 2008 T-SQL Performance Tuning

can any one pls share how to find and resolving blocking using ssms? can any one provide me clear idea pls?

need help on index tuning

Thread by: sqldbarocks, Jan 12, 2011, 4 replies, in forum: SQL Server 2008 T-SQL Performance Tuning

Hi All, Mine is a small firm where 20 users are hitting the dbs for their dev part.Recently our dba left our orgnisation and I was appointed for the...