Thank you all for your replies and suggestions! Much appreciated!

Hi,

Thank you for your feedback, and for confirming my suspicions....
I inherited this server so the setup is not great:
* I fixed the maintenance processes with...

Nope, no maintenance plan, it is T-SQL code I created

With regards to the question of bulk load or spread out: it is spread out over the day.

I have a daily job that runs at 5 AM which reorganize/rebuilds indexes based on fragmentation.
But I see the auto update of the statistics has a date later then...

Just an update: I have decided to go with Change Data Capture. And scheduling a SSIS package every X minutes to write the changes to the new DB. It won't...

Hi Gail,

Thanks for your reply.

I have investigated the Adhoc queries and it is in fact all valid. I have traced most of them down to Dynamic SQL within stored procs....

Hi,

Just an update - I know it is an old post... But I still had no luck in shrinking the data file.

I tried shrinking in smaller chucks but it had...

Thanks Gail,

So you would advise against it?

The better solution would rather be hardware and SQL tuning?

Hi,

Can I ask a dumb question.. 🙂

What will happen if the value of local_net_address is not what the external users are using to connect to the DB?

For example:...

Nope there are no external sources / references.

It is an UPDATE and INSERT statement from 1 DB to another to keep the 2 in synch - UPDATE if the records...

Yes, it has a clustered and a few non-clustered indexes.

I did rebuild all indexes on this table.

I will apply your script to my DB..hope it works..

Thanks for you help ...

Ok, of course... I did not think about the ghost records...

I tried forcing the ghost cleanup process using::

DBCC ForceGhostCleanup;

But it does not seem to have an effect..?

Hi,

The shrink commands I used were:

DBCC Shrinkfile(dataFileNameHere,1)

DBCC Shrinkfile(logFileNameHere,1)

DBCC Shrinkdatabase(databaseNameHere)

The result of the query:

FileSizeMBUsedSpaceMBUnusedSpaceMBDBFileName

341463.06120929.25 220533.81 ***data

132.88 7.75...

Hi,

Thank you for the replies.

Some answers to your questions:

The wait types I see are CXPackets.

I see a lot of parallel queries during this time - the same parallel queries we...