Search Results | SQL Server Performance Forums

How to Change the owned Schemas for a user

Thread by: y.koteswarrao, Sep 25, 2010, 2 replies, in forum: SQL Server 2005 General DBA Questions

Hi, I have given a user db_datareader owned_schema and now i what to change it to db_datawriter ,but unable to change because db_datareader is in...

How to monitor the memory usage through DBCC Perf

Thread by: y.koteswarrao, Jul 14, 2010, 3 replies, in forum: SQL Server 2005 General DBA Questions

Hi, Is it possible to monitor the memory usage through DBCC Perf command.......... Koteswarrao

Login Locked Out Tab is disabled

Thread by: y.koteswarrao, Jul 14, 2010, 2 replies, in forum: SQL Server 2005 General DBA Questions

Hi, Iam a sysadmin,i saw that Login properties->status->"Login is Locked Out tab is showing disabled always,unable to check or uncheck the...

system tables in master database

Thread by: y.koteswarrao, Jun 17, 2010, 4 replies, in forum: SQL Server 2005 General DBA Questions

what the system tables available in the master database in sqlserver 2005? i know that in sqlserver 2005 system tables are hidden,i want to know that...

Logical Backup using Export/Import

Thread by: y.koteswarrao, Mar 2, 2010, 2 replies, in forum: SQL Server 2005 General DBA Questions

Hi,this question is asked by an interviewer,how to take the logical backup using export/import... is it possible or feature available in sqlserver...

Responsibilities for L3 Position as DBA

Thread by: y.koteswarrao, Jan 25, 2010, 4 replies, in forum: SQL Server 2005 General DBA Questions

Hi,can any one tell me what would be the roles and responsibilites as a DBA for L3 position. Thanks Koteswar Rao

LogShipping

Thread by: y.koteswarrao, Jul 13, 2009, 3 replies, in forum: SQL Server 2005 Log Shipping

Hi,Iam configuring logshipping for the first time, i configured logshipping successfully,transaction backup is happing but it is not copying and...

Performance counters baseline values

Thread by: y.koteswarrao, Apr 11, 2009, 1 replies, in forum: SQL Server 2005 Performance Tuning for DBAs

Hi , Iam new DBA i have gone through the many books for performance counter baseline values(Recommned values) many have give different values, could...

Transaction Log file Backup

Thread by: y.koteswarrao, Nov 7, 2008, 6 replies, in forum: SQL Server 2005 General DBA Questions

Hi DBA guru's iam unable to back up the transaction log, because it is in disable state,how to enable the transaction log? Koteswar rao.Y

Transation Log File is missing/Lost

Thread by: y.koteswarrao, Nov 7, 2008, 4 replies, in forum: SQL Server 2005 General DBA Questions

Hi DBA guru's How to recover/get back the lost/missing Transaction log file? Koteswar Rao.Y

DataBase Space Management

Thread by: y.koteswarrao, Nov 1, 2008, 1 replies, in forum: SQL Server 2005 T-SQL Performance Tuning

Hi All, How to trace the Database space of all database rather than single database by using sp_spaceused? Koteswar Rao.Y

Performance Tips

Thread by: y.koteswarrao, Oct 25, 2008, 3 replies, in forum: SQL Server 2005 Performance Tuning for DBAs

How to find the long running queries & Network performance issues? Regards koteswar Rao.Y

Recomded values for sql-server counters?

Thread by: y.koteswarrao, Oct 15, 2008, 2 replies, in forum: SQL Server 2005 Performance Tuning for DBAs

Hi All, Iam new to the sql-server performance topic, i like to know the recomended values for the sql-server counter? Could any let me know. Thanks...

User unable to open the application

Thread by: y.koteswarrao, May 12, 2008, 1 replies, in forum: SQL Server 2005 Performance Tuning for DBAs

Hi, the user is unable to open the application......... i can i know what wuld be the problem..how to slove the issue.( performance issue and network...