I realise that I am a bit late to the party. The percentage increase is one that many people get wrong.

When I demonstrate similar issues, I like to use 100%...

If I am reading this correctly, you are trying to kill sessions that has been inactive for more than 8 hours.

What is the table defintion of StatsAdminTest.dbo.tbactiverole? Is your SPID...

I've had to troubleshoot queries where the developer had forgotten an ELSE clause and the whole thing returned NULL (which was not expected).

this will yield NULL due to not having...

Brandie Tarvin (1/5/2017)

---

Rasmus Remmer Bielidt (1/5/2017)

---

Both options have their uses for sure.

I didn't see anybody making this point, but COALESCE() absolutely needs a non-null argument or it will throw an...

Both options have their uses for sure.

I didn't see anybody making this point, but COALESCE() absolutely needs a non-null argument or it will throw an error where a case without...

Upgrading our HP Proliant G9 Xeon server to the newest BIOS and setting the NUMA Group to FLAT also resolved our issue.

Thanks for helping out.

Well spotted!

As it turns out, we're also using G9 HP with Xeon 26xx processors. I've asked our systems department to upgrade the BIOS and set the NUMA Group Size Optimization...

I am not sure what the default settings are, but ours look like this - I don't think they have been changed.

[font="Courier New"]

name ...

Hi Frant101,

No, havent found a fix yet. Keep me posted if you do.

Andrew, thanks for the insight. I know the differential is all changed data since last full backup. I just put this schedule in place and will monitor the size of...

Indeed, it was accidentally omitted. Full backups are run on saturdays after dbcc and index maintenance.

Will DBCC CHECKDB ever fail a job step? If not, how does one normally get...

Thank you for all the replies, tips and hints. They are very useful.

Using Ola's solution, I have now set up a solution where the production database gets maintained (DBCC and...

This task was dumped on my desk because I recently...

Thanks for the answers. Losing all my backup files in one go was not what I aim to do. I suppose that has to do with possible corruption in the...

Hm, I thought keeping all the related backups in a single file would make things simpler.

If I need to restore a backup from today, I will restore from device0, yesterday...