dataplatform.blog
SQL Performance

Claus Munch

Untrusted Foreign Keys and how to fix them

Untrusted Foreign Keys are something that is often an overlooked performance issue.
Let's fix that "easily".

SQL Tips & Tricks
(updated on )

Claus Munch

Idempotent SQL change script

Today I had a small chat with one of our developers, about adding a column to a table "the right way". I told him, that depending on how they needed to deploy it, it might be beneficial to make it idempotent.

SQL Tips & Tricks
(updated on )

Claus Munch

Database Mirroring to offsite server

Using SQL Server Database Mirroring to offsite servers, can at times be tricky, as latency becomes an issue.
At a recent engagement, they where experiencing that their mirror got suspended several times a day.

SQL Tips & Tricks
(updated on )

Claus Munch

Backup/Restore progress

Sometimes you just need to have an idea of how long a backup/restore has been running or maybe for how long it will roughly run.
Here's a small script, that will give you these indications.