Search Results | SQL Server Performance Forums

Errors

Thread by: Rabani, Sep 10, 2009, 1 replies, in forum: SQL Server 2005 General DBA Questions

Hi , Can somebody please, let me know that is there any way that we can find the error in a log file which is related to the error occured during...

SQL connection Error

Post by: Rabani, Aug 26, 2009 in forum: SQL Server 2005 General DBA Questions

Thank you MohammedU !!! It worked. I really appreciate your help.

SQL connection Error

Thread by: Rabani, Aug 25, 2009, 2 replies, in forum: SQL Server 2005 General DBA Questions

Hi Friends, I am trying to connect to the local instance in my machine. I had deleted some Databases. As soon as I deleted them when It gave me the...

Acess error

Thread by: Rabani, Apr 19, 2009, 2 replies, in forum: SQL Server 2008 General DBA Questions

Hi , Ineed to move data from my test envirnoment in a MS SQL Server 2000database to a staging envirnoment, also a MS SQL Server 2000 database.I...

Firewall

Thread by: Rabani, Apr 9, 2009, 2 replies, in forum: SQL Server 2005 Log Shipping

Hi Can any one please, tell me that when we configure log shipping do we have to open a firewall from the destination server to the source server...

Transaction log file space usage check

Thread by: Rabani, Mar 8, 2009, 9 replies, in forum: SQL Server 2005 Performance Tuning for DBAs

Hi Freinds, Is there any query that can retrieve the current usage by transaction log file. Please, help. Thanks, Rabani

Memory

Thread by: Rabani, Feb 24, 2009, 1 replies, in forum: SQL Server 2008 Performance Tuning for DBAs

Hi, Can any body let me know that Does Distrib.exe consume a lot of memory in the SQL Server? What would be the possible reasons or an exessive...

Store procedure

Thread by: Rabani, Jan 13, 2009, 6 replies, in forum: SQL Server 2005 Performance Tuning for DBAs

Hi , Can anybody let me know if a store procedure is taking a high cpu time and high duration to execute , how can we fix this problem. Thanks,...

Maximum User Connections

Thread by: Rabani, Jan 11, 2009, 2 replies, in forum: SQL Server 2005 Performance Tuning for DBAs

Hi, Can somebody clearify that what performance issue occurs if the maximum user connection is exceeded. Thanks, Rabani

Locking

Post by: Rabani, Jan 11, 2009 in forum: SQL Server 2005 General Developer Questions

Hi Satya, Thanks for the quick response. Actually I don't have any problem. I just wanted to know what happens in that situation. Also I have one...

Locking

Thread by: Rabani, Jan 11, 2009, 4 replies, in forum: SQL Server 2005 General Developer Questions

Hi, Can anybody let me know that what happens if there is 95 % locking on MSSQL 2005. How good is it. Please, advice. Thanks, Rabani

Sync tables between two servers

Post by: Rabani, Jan 6, 2009 in forum: Getting Started

Hi Elizabeth , Thanks a lot . It was really the easiest and fast one. Thanks, Rabani

Foregin keys

Thread by: Rabani, Dec 31, 2008, 2 replies, in forum: SQL Server 2005 General DBA Questions

Hi, Can anybody suggest that how can we delete a table referenced by a foreign keys. Specially the table that is referenced by multiple foreign keys...

Sync tables between two servers

Post by: Rabani, Dec 21, 2008 in forum: Getting Started

Hi Saty Actually it is only one time task. I need to sync of the data between those two tables. Some are in same servers but different database and...

Sync tables between two servers

Thread by: Rabani, Dec 19, 2008, 6 replies, in forum: Getting Started

Hi, Can anybody give me an idea that how can i move data from a table in one server to another server into the same table which doesn't have any...

Upgrade

Post by: Rabani, Nov 4, 2008 in forum: SQL Server 2005 General DBA Questions

Hi Luis, Actually it is the upgrade of SQL Server but I have to make sure that the application which it has right now are compatible with the...

Upgrade

Thread by: Rabani, Nov 3, 2008, 3 replies, in forum: SQL Server 2005 General DBA Questions

Hi , Can any body let me know that how do we find the compatiblity of upgrading MSSQL server without using upgrade advisor? Thanks, Rabani

Failed jobs

Post by: Rabani, Oct 28, 2008 in forum: SQL Server 2005 General DBA Questions

Thank you everybody for helping me out. Rabani

Failed jobs

Thread by: Rabani, Oct 26, 2008, 5 replies, in forum: SQL Server 2005 General DBA Questions

Hi , Can somebody please, help me with a script to send an alert upon the failure of a job. I need a script that will automatically send an email...

Failover

Thread by: Rabani, Oct 21, 2008, 2 replies, in forum: SQL Server 2005 Clustering

Hi, Can somebody please, let me know that how do we know exactly that a server has failed over to the secondary node. Also what does that effect the...