Search Results | SQL Server Performance Forums

Search for similar names

Thread by: Anoop, Sep 12, 2008, 3 replies, in forum: SQL Server 2005 General DBA Questions

Hi All, I need a query to that will return similar names. For an example, if i search for mike, it should also return michael. Is this possible in...

PULL or PUSH subscription

Thread by: Anoop, Sep 8, 2008, 1 replies, in forum: General DBA Questions

- SQL Server 2000 -Transactional Replication- 1 subscriber - Distributor and subscriber on the same server- Subscriber always online Would you...

Script to Rebuild indexes based on the average fragmentation percentage value -- SQL Server 2005

Thread by: Anoop, Aug 7, 2008, 1 replies, in forum: Contribute Your Performance and Clustering Tips

I created this stored procedure to Rebuild indexes based on the average fragmentation percentage value. It works pretty well for me. I thought of...

Dynamic use statement

Thread by: Anoop, Aug 6, 2008, 6 replies, in forum: SQL Server 2005 General DBA Questions

Hi All, I am tyring to use the dynamic use statement in a stored procedure using the following script. The script runs successfully but it doesn't...

Trace for Database Tuning Advisor

Thread by: Anoop, Jul 15, 2008, 5 replies, in forum: SQL Server 2005 Performance Tuning for DBAs

Hi All, I am using TUNING Template to generate a trace file for DTA and planning to add a filter to remove rows with Duration = 0 or (<1). I have...

Excluding delete statements from replication

Thread by: Anoop, Apr 28, 2008, 3 replies, in forum: General DBA Questions

Hi All, I used @del_cmd = N'None' to stop replicating delete statements for one of my table but it caused update statements to stop replicating as...

Intalling SP4 on Replication and Production server

Thread by: Anoop, Feb 11, 2008, 1 replies, in forum: General DBA Questions

Hi All, I just took over DBA responsibilities and noticed that the production and replication servers have SP3 installed for 2000. I am planning to...

Database port

Thread by: Anoop, Dec 11, 2007, 3 replies, in forum: General DBA Questions

Hi All, How would you find out which port each db is using in SQL Server 2000? Thanks,

Multivalue Parameters

Thread by: Anoop, Oct 25, 2007, 1 replies, in forum: SQL Server 2005 Reporting Services

Hi, I am using multivalue paramenter in my report. It shows the multivalues in the report preview window but it shows up as a regular drop down at...

Generate Scripts

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

Hi All, SQL 2000 Enterprise manager has option to "Create one file per object" when Generating SQL Scripts for database objects. But I couldn't...

How to export database objects to multiple files

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

Hi There, Is there a way to export database objects to multiple files? Export wizard only exports to a single file. Can this be done through a...

Unable to Kill a Process

Thread by: Anoop, Oct 2, 2007, 5 replies, in forum: General DBA Questions

Hi There, I am trying to kill a process but it deosn't seem to go away. On the Activity Monitor window, it shows KILLED/ROLLBACK with the status...

MOM database

Thread by: Anoop, Aug 30, 2007, 1 replies, in forum: General DBA Questions

Hi All, I have question regarding MOM database. The windows task that runs MOM.Datawarehousing.DTSPackageGenerator.exe runs successfully,but it...

DB Restore takes longer

Thread by: Anoop, Aug 9, 2007, 9 replies, in forum: General DBA Questions

Hi There, I am restoring a production backup onto the test server and it takes about 55 min. to restore when it used to take only about 16min as of...

Database backup file size

Thread by: Anoop, Aug 1, 2007, 8 replies, in forum: General DBA Questions

Hi All, I have a job to backup db every night and i have noticed that the size of the backup is increasing by 0.1GB every night even though the...