To expand upon this, and maybe provide some ideas that can ease your pain, here are some thoughts.  I had this same situation a while back. The difference was...

The example is for a query called by the Customer List page of the web application.  It will execute 1000's of times a day.

Execution plans are the same:  clustered Index Scan (Clustered) ; Cost: 100%

Yep - same query, same result.  Just slower.

Tomorrow p.m., we have a 2 hour maintenance window.  I will try...

Sorry - but what is AG or WFC?

Does the hash code compress the data?  Can you reverse out the sqlstatement from the hash result?

Here are the Update, Insert and Delete triggers for one of the smaller tables in the database.

------------------------------------------------------------------------------------------
----- INSERT -----------------------------------------------------------------------------
------------------------------------------------------------------------------------------
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE  TRIGGER [dbo].[o_choice_Audit_Insert] ON...

Hi.

Here is an update.  I have ran the code above.  Here are the #'s  (mdf/ldf):

Original size:  566,086,656 // 50,003,456

After tableoption : same

After Update:  935,619,456 // 584,126,656  (6 hours later)

After Alter...

Jeff,

Wow.  Thank you for all of the above.  You are correct with the backup being huge because of the audit data.  I have a lot to think about.

Thanks!

Jeff,

Would it help to split the table into 2.   One with all data except the varchar(max) and one with the same ID and the varchar(max) only?

Mike

Sorry about that -- I thought I had posted that #.  It is 6,957,805 records between 4000 & 8000.

Mike

This is the reason why I'm asking how many values in the SQLStatement table there are that fall in between the two numbers I provided.  It'll let us know for...

Here is the code from when I tell SQL server to script the creation of it:

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[Audit](
[AuditID] [bigint] IDENTITY(1,1) NOT NULL,
[AuditDate] [datetime]...

How would I check for network discrepancy/latency?  Also, why would the following happen:

Use master  -- note: No table named product
select * from xxx.dbo.product - 8 seconds

Yes, my local machine is the server.  So the 4 seconds is getting the data on the same notebook where the data is stored and SQL is running.
However, I...

I am trying to figure out queues.  Doing a batch of items doesn't solve the issue.  If my queue was a list of incoming orders and I have limited stock,...