1) Who said anything about nightly index rebuild? It sounded to me like you did some massive cleanup process that removed hundreds of GB from your database and you want...

I'd really prefer not to have to do a nightly rebuild on every index - don't think I have enough time to complete that nightly anyway.

Can I just do a...

I need the max

This seems to work :

SELECT * FROM [SQLNODEBSTAGE].[PEC_PROD].[DBO].[Staging_Eligibility]

WHERE (select max(staging_eligibility_id) FROM [SQLNODEBSTAGE].[PEC_PROD].[DBO].[Staging_Eligibility]) <> (SELECT MAX(staging_eligibility_id) FROM [SQLNODEBSTAGE].[STAGING_Archive].[DBO].[Staging_Eligibility_archive])

The staging tables will not be deleted only...

Thanks . I figure it out. It really was a NULL.

I am querying in an A/G group and needed to add a linked server to reference my primary to get...

Yes.

Thanks everyone most helpful.

Thanks.

I think I found one that is pretty good - has fiscal dates (Quarters/Year end, etc)

Thanks everyone..that worked!

Thanks, but I'm looking for somthing similar to this..(but I can't this working - nothing prints)

USE Master;

GO

SET NOCOUNT ON

-- 1 - Variable declaration

DECLARE @dbName sysname...

Wish we could. End users need to be able to choose parameters.

It would be ideal if the end user...

Kinda figured, but was hoping for something.

Thanks Steve.

Without the TF 1117 the splitting of the tempdb into multiple files is likely to be an utterly useless exercise as the load will more or less end up in...

this is pretty much what I was thinking of doing...thanks!

Agreed Jeff.

The trigger(s) caused a huge series of updates to several tables, logging, auditing, etc.

This was a one time update. We are a really busy shop..so 30G growth...

Hi Jeff,

Well it is fixed. Thanks everyone. I did run it with Gail's suggestion and it used about 30G worth of temp db space.

So for us, that was a...