Search Results | SQL Server Performance Forums

Does database backup process fail if the database to be backed up is already corrupt?

Thread by: bhushank21, Feb 8, 2012, 1 replies, in forum: ALL SQL SERVER QUESTIONS

Hi all, Does database backup process fail if the database to be backed up is already corrupt? We are using SQL Server 2005. We wanted to know if...

DISABLE TRIGGER CODE is taking a long time to execute

Thread by: bhushank21, Nov 11, 2009, 1 replies, in forum: SQL Server 2005 General DBA Questions

Hi, I have a code to disable the trigger. It is taking a long time to execute. Also, i tried to manually disable using the SQL 2005 Object explorer...

Retrieve Stored Procedure Parameter Values within the procedure

Thread by: bhushank21, Sep 16, 2009, 5 replies, in forum: SQL Server 2005 General Developer Questions

Hi, WE have a stored procedure which has say, 2 input parameters. WE need to log the parameter values whenever this procedure gets executed. create...

Relation of Database size to performance

Thread by: bhushank21, Mar 5, 2008, 4 replies, in forum: SQL Server 2005 General DBA Questions

Our application database is 40 Gb. There are many History tables in it. These account for almost 15Gb out of 40 Gb. Queries that access these tables...

SQL 2000 and SQL 2005

Thread by: bhushank21, Jan 21, 2008, 5 replies, in forum: SQL Server 2005 General DBA Questions

Can we install SQL 2000 on a server which already has SQL 2005 installed? SQL 2005 may have been installed as either Default or Named Instance.

Stored procedure execution time: Query Analyzer vs. Web application

Thread by: bhushank21, Dec 31, 2007, 2 replies, in forum: SQL Server 2005 T-SQL Performance Tuning

I have a Webserver and a SQL server in same network. A certain stored procedure named ABC that is present on the SQL Server takes just 5 seconds to...

Can SQL Server 2005 Named Instance use 1433 port?

Thread by: bhushank21, Nov 2, 2007, 4 replies, in forum: SQL Server 2005 General DBA Questions

We have SQL Server 2000 and Sql Server 2005 installed on the same machine. SQL Server 2005 is a named Instance and not the default instance. By...

Very slow SQL Server 2005 Instance

Thread by: bhushank21, Oct 15, 2007, 3 replies, in forum: SQL Server 2005 General DBA Questions

We have a quick query regarding SQL performance.We have SQL Server 2000 (32 Bit) and SQL Server 2005 (64 Bit) as two separate instances on our DB...

Best backup-restore strategy

Thread by: bhushank21, Aug 31, 2007, 3 replies, in forum: SQL Server 2005 General DBA Questions

Hi, I have two SQL Server 2005 servers with databases A and B that need to be in sync. Both have Simple Recovery Model. I created a full back up of...

32 bit vs. 64 bit SQL Server 2005

Thread by: bhushank21, Jul 18, 2007, 2 replies, in forum: SQL Server 2005 General DBA Questions

We are planning to migrate to 64 bit SQL Server 2005 with 64 bit OS on a production server. Locally, all developers have 32 bit OS and 32 bit SQL...

Any known performance issues with Pivot?

Thread by: bhushank21, Jun 6, 2007, 1 replies, in forum: SQL Server 2005 T-SQL Performance Tuning

SQL 2005 introduced PIVOT for cross tab reports. Are there any known performance issues of using the PIVOT keyword? Or is it better to do the cross...

Table aliases in SQL 2005 bad?

Thread by: bhushank21, May 24, 2007, 26 replies, in forum: SQL Server 2005 T-SQL Performance Tuning

Hello, Recently I saw that in one of the data models, column names were prefixed with table names. For e.g. The Employee table had the columns named...