Search Results | SQL Server Performance Forums

Suspect Database - Replication issue

Thread by: simondm, Nov 5, 2007, 1 replies, in forum: SQL Server 2005 General DBA Questions

Hi all, I have a dreaded suspect database today due to a hardware failure. I have a backup and am restoring it now as another db name. The suspect...

FullText queries slow

Thread by: simondm, May 31, 2007, 1 replies, in forum: SQL Server 2005 Performance Tuning for DBAs

Hi, I currently have a large table (35 million rows, over 80GB). I have one varchar(max) column on the table that is used in the fulltext index. To...

Need more speed

Thread by: simondm, Jun 13, 2006, 3 replies, in forum: SQL Server 2005 Performance Tuning for DBAs

Hi All, I have the following query: SELECT Vertical, COUNT(*)/7 as [Pages], SUM(Views)/7 as [Views] FROM CONTAINSTABLE([PagesContents], [Body],...

Moving large table

Thread by: simondm, Feb 27, 2006, 2 replies, in forum: SQL Server 2005 General DBA Questions

Hi All, I have a database on my 2005 cluster that contains a table with 110GB of data in it. I need to archive this data onto another...

ntext & nvarchar(max) storage methods

Thread by: simondm, Feb 17, 2006, 1 replies, in forum: SQL Server 2005 Performance Tuning for DBAs

I'm having a problem with a table that contains a IDENTITY column (with clustered index) and a ntext column. The table has approx 20 million rows...

Execution Plan Wrong?

Thread by: simondm, Nov 8, 2005, 5 replies, in forum: T-SQL Performance Tuning for Developers

I have this table with just over 100million rows: <pre id="code"> CREATE TABLE [MyTable] (<br...

Parallel Data Loads

Thread by: simondm, Sep 21, 2005, 3 replies, in forum: T-SQL Performance Tuning for Developers

Hi, I'm trying to setup a DTS package that will have two threads performing BULK INSERTS into the same table. I've got the DTS package doing the...

Distribution Cleanup Agent Deadlock

Thread by: simondm, Sep 4, 2005, 1 replies, in forum: Performance Tuning for SQL Server Replication

Hi all, I have a problem with my distibution database where the clean up agent keeps failing because of a deadlock issue. This is causing the...

DTC - Cannot Enlist Transaction

Thread by: simondm, Aug 23, 2005, 9 replies, in forum: General DBA Questions

Hi, I've got two boxes: ServerA is a standalone Windows 2000 Std Server with SQL 2000 std SP3 ServerB is a clustered (act/pas) Windows 2003 Ent...

Moving data between files

Thread by: simondm, May 23, 2005, 1 replies, in forum: General DBA Questions

Hi, I have a database which has two files in the same filegroup (PRIMARY) and on different drives. The 2nd file (ndf) I need to move to another...

EMC MirrorView

Thread by: simondm, May 17, 2005, 3 replies, in forum: Performance Tuning for Hardware Configurations

Hi, My company currenty uses an EMX CX-700 SAN to host all our SQL server clusters. After some aggravation it now works very well - so I'm a happy...

Full Text on Cluster

Thread by: simondm, Apr 5, 2005, 5 replies, in forum: SQL Server Clustering

I'm trying to re-install full text on my cluster as per this knowledge base article: <br /<a target="_blank"...

Database Snapshot (EMC SAN)

Thread by: simondm, Apr 4, 2005, 14 replies, in forum: Performance Tuning for Hardware Configurations

This is a little bit specific but I'm really running out of places to turn: I've got an EMC CX-700 SAN which I host several clusters...

SQL Server Setup Script

Thread by: simondm, Feb 25, 2005, 1 replies, in forum: Contribute Your SQL Server Scripts

I recently had to install SQL on many many many identical machines. Needless to say I didn't fancy doing it all manually! The batch script does an...

Heavy Context Switching

Thread by: simondm, Feb 11, 2005, 2 replies, in forum: Performance Tuning for DBAs

I've got a problem with a machine (Win2k SQL 2000 Ent SP3 (81<img src='/community/emoticons/emotion-11.gif' alt='8)' /> 8 procs 8GB RAM) where I am...

Linked Server Problem

Thread by: simondm, Jan 17, 2005, 1 replies, in forum: General DBA Questions

Hi, Running the code below I'm suddenly getting an error: DELETE FROM OrganisationManager FROM OrganisationManager OM INNER JOIN Organisation O ON...

Memory Setting

Thread by: simondm, Jan 14, 2005, 3 replies, in forum: General DBA Questions

Hi, I have a Win 2003 Ent Cluster (2 node active/passive). The servers have 8GB of RAM. We have the 3GB and PAE switches set in boot.ini. SQL 2000...

Collations and Superscript

Thread by: simondm, Dec 13, 2004, 1 replies, in forum: General DBA Questions

Does anyone know how (and why) SQL 2000 handles superscript? Here's my problem. On my old server which is in SQL_Latin1_General_CP1_CI_AS, if I run...

SQL Server 2000 SP4?

Thread by: simondm, Nov 10, 2004, 2 replies, in forum: General DBA Questions

Does anyone know anything about Service Pack 4 for SQL 2000 or where I can find out more? There are bits on the web, and at the SQL Conference in...

Snapshot Replication Blocking

Thread by: simondm, Nov 3, 2004, 0 replies, in forum: Performance Tuning for SQL Server Replication

I've got a problem with a pull subscription to a snapshot publication. Whenever I add the subscription I get a blocking problem and it never...