Yes he has restarted SSMS quite a few times and it still happens.... The strange thing is that this does not happen with all his queries. It seems random

Hi

I checked that - that is the autoCommit I was referring to... it aint ticked...

I would like to ask one more thing:
I am seeing a high ratio of Recompilation - on average over 50% of incoming batches and of Compilations per second.
How...

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 ...