NULLIF denominators turn zero into NULL for a deliberate division policy. This complete example keeps zero, missing inputs and integer truncation visible beside the decimal result.
SQL SERVER – Change the Port of Service Broker Configuration
Service Broker hit error 9692 because another app used its port. Here is how to change the port of Service Broker by creating its endpoint on a new port.
SQL SERVER – Introduction to Service Broker
Service Broker supports transactional asynchronous messaging within SQL Server. I separate queued work from the application that processes it.
Organising Notes You Have Already Written
Learn to organise notes around problems, useful search terms, and review dates so earlier SQL Server work becomes easy to find and trust.
SQL SERVER – SP_CONFIGURE – Displays or Changes Global Configuration Settings
The global configuration list shows configured and effective SQL Server settings. I compare both before deciding that a change has taken effect.
SQL SERVER – 2008 – User Account – sa or sysadmin
SQL Server 2008 treats sysadmin as the modern home for the old sa account rights. Here is what changed and why sa now needs a password.
REVERSE: Keep Trailing Spaces in String Reversal
REVERSE changes character order while keeping supplied spaces. Use visible boundaries and byte counts to distinguish empty and missing inputs.