(1) Make sure any relevant statistics on the table are up to date.

(2) Easiest might be to add:

OPTION(RECOMPILE)

to the end of the SQL and see if it helps; iirc, SQL...

Maybe like this?:

select 
       s.MBR_NAME                ...

Or maybe just this:

SELECT CompanyName, 
    LEFT(CompanyName, EndOfWord1) AS [First Word], 
    LEFT(CompanyName, EndOfWord2) AS [First  + Second Word],
 ...

You need to look at the "Estimated" plan for the one that doesn't work, just to be sure.  See if anywhere SQL is referencing or "output"ing the restricted column.

What is the specific error message (and error number and status) you get? (Using dummy column name(s) as needed, of course).

What is the query plan?  Does it give any help...

• This reply was modified 1 years, 11 months ago by ScottPletcher.

You don't need to export to Excel to do the comparison, you can do it directly in SQL Server.

Look at the files on the drive and see if there is a large, obsolete file(s) (perhaps old backups?).

Depending on the version of SQL Server, you might also be able...

Try this.  It may not work because of the GROUPing.  You might have to do the GROUPing after concatenating the subquery results.

SELECT
DISTINCT 
G.[Period], 
G.[Sector], 
G.RID, 
STUFF
((
SELECT 
DISTINCT
...

Is your tempdb database on the C: drive?  If so, that could theoretically cause the problem.

By the way, 9GB is a very tiny amount of free space on a drive. ...

I don't think you can do much for that table itself.

You need to look at the code that is UPDATEing that table and make sure that code is efficient.  Also,...

Would you be able to use TRUNCATE TABLE instead to remove all the rows?  That will be vastly faster.

If the table has an identity column, and you want to maintain...

The inserted and deleted "tables" only exist within the direct code of a trigger.  You can't reference them from an external query.  You'd need to write the inserted and deleted...

This is somewhat confusing, but something like this would likely do what you want to do:

SET ANSI_NULLS ON;
SET QUOTED_IDENTIFIER ON;
GO
CREATE TRIGGER [dbo].[tr_ORDERID]
ON [dbo].[MYCUSTOMERS]
AFTER UPDATE
AS
SET NOCOUNT ON;
BEGIN
IF UPDATE(ORDERID)
BEGIN
...

synchronous

Code only needs to be schedule on the first and last Thursday of the month, since those are the only 2 days it might need to do something.

As to simplification,...