Awesome move on SQLServerCentral's part - outstanding!

The book on Windowing functions is a must-read!

I'm not clear if this will allow for searches within SSIS packages?

Gail,

'Prod' system for Finance what-if scenarios - which we rebuild every morning from the previous day's 'true' prod.

They run all kinds of queries against the old data - so...

John,

I need the File_ID to pass to DBCC SHRINKFILE - but I'm all ears in terms of suggestions.

SELECT @Log = FILE_ID,

@DB = Name

FROM sys.database_files

WHERE type_desc = ''Log'';

DBCC SHRINKFILE( @Log, TRUNCATEONLY...

Ok - so I threw together below - which works around it. It seems like the Is_Read_Only setting is a "bug" depending upon where you look?

DECLARE

@LogSMALLINT,

@DBSYSNAME,

@Is_Read_OnlyBIT,

@FalseBIT= 0;

SELECT

@Is_Read_Only = SD.is_read_only,

@Log =...

Donalith - I disagree - usually the second I create the index they are used an not 'resuggested.'

I'm going to reboot, run

DBCC dbreindex ([tblInvoices])

UPDATE STATISTICS [tblInvoices] WITH FULLSCAN

And see what...

Gazareth - no - it didn't - that was the source of my post 😉

Why do you have MAXDOP set to 1?

Doug

Spot on Jared - that was exactly what I had come up with - here's a snippet ( This was to handle the delete case, remember, the Insert and Update...

Ravi,

I was saying specifically through the MERGE statement, where you just DELETE.

Thanks buddy,

Doug

Brandie,

Do you have a short example?

Thanks for the assist,

Doug

Jared,

I was saying specifically through the MERGE statement, where you just DELETE.

Thanks for giving it a shot,

Doug

Lynn,

That rocked! - How obscure!

That knocked 10 seconds off of a crucial SQL which was seeing DEADLOCKs.

Thanks so much,

Doug

Most excellent response.

Doug

Jason,

That worked perfectly - it seems more syntactically complete than my solution, even though they perf out 50/50 in plan comparison.

Doug