- Add a second log file.

- To find out what is filling the transaction log

USE [DBNAME];

DBCC OPENTRAN;

- check log backups

- if you have replication, check the log reader is running.

-...

Not a solution but something to look into...

MERGE will request a HASH join. Run the following when the query is running to see how much memory it is requesting.

SELECT...

You could add a new filegroup set the size you require. Then rebuild the index on the new filegroup (ON <<new filegroup>>) using ONLINE = ON, DROP_EXISTING = ON....

Michael R. OBrien Jr (1/2/2013)

---

I guess I have never been a fan of triple quoting, I usually use CHAR(39) I find it is a lot easier to read for others:

SELECT...

I agree, much tidier.

EXEC ('SELECT ''O'' + CHAR(39) + ''Neal''')

Yes there can be performance benefits. Have a read of this article first though...

From books online:

The MERGE statement should not be used when using queued updating replication. The MERGE and queued updating trigger are not compatible. Replace the MERGE statement with an insert...

To move a heap you would need to create a clustered index on the new filegroup...

For me it like a scene from the film Zulu... I'm massively outnumbered from an enemy with very blunt instruments. The odd one can shoot but normally misses.

I have...

To give more context this is my table.

CREATE TABLE [dbo].[LabelValues](

[UserAccountID] [int] NOT NULL,

[ContactID] [int] NOT NULL,

[STRING1] [nvarchar](255) NULL,

[STRING2] [nvarchar](255) NULL,

[STRING3] [nvarchar](255) NULL,

[STRING4] [nvarchar](255) NULL,

[STRING5] [nvarchar](255) NULL,

[STRING6] [nvarchar](255) NULL,

[STRING7] [nvarchar](255)...