Well, if you're having a problem with a database, stop shrinking it. Making problems worse is usually a bad idea. Shrink doesn't help matters, this isn't MS Access.

Shrink should never...

Well, 'when doing a shrink' should be a rare event in the first place.

I'm happy to have enough free space in the DB to accommodate 6 months of expected data...

You can, it'll clean up coding a bit, won't improve performance or change how the query runs.

WITH FilteredTable4 AS (

SELECT <whatever columns needed>

FROM table_4

...

Ok, so the query fragment i gave earlier is correct, it was just short a clause.

SELECT Booking_ID FROM dbo.BOOKING AS b

WHERE DG_FLG != 'Y' AND

NOT EXISTS (SELECT 1 FROM...

Without seeing the query, absolutely no idea.

You can't go straight from 2000 to 2012. You'll need to either migrate 2000 to 2005 and then 2005 to 2012 or 2000 to 2008/2008 R2 and then 2008 to...

Which wasn't what you said in your initial post.

What I...

Without table definition and usable sample data I'm guessing, but...

WHERE NOT EXISTS (SELECT 1 FROM <Table Name> ib WHERE ib.Booking_ID = <outer table reference>.Booking_ID AND Flag = 'Y')

If you want...

Table definitions and index definitions as well please

Could you post the plan for just that query run in isolation, not that and every single other statement in what looks like...

VIII (2/27/2014)

---

thanks, but I think the problem is worse than that

when I try to generate script, nothing to get

when I try to export data, same message 'SQL Server detected a...

Grow the file or add additional files on another drive if it filled as part of regular activity.

On SQL 2000 it's very hard to identify queries using TempDB, the DMVs...

Domain update finally went...

Steve Jones - SSC Editor (2/26/2014)

---

Not GoDaddy, I hope. They lost my wife's DNS records and I had to play tech...

Don't waste your time. Partitioning is not a performance tuning technique. While...

Google SQL Server statistics and do some reading. Far more than I can summarise here.