Error 8134 means an expression tried to divide by zero. I choose the intended undefined-result behavior before guarding the division.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
How to Attach a Database Without Log File in SQL Server
To attach a database without log file, run CREATE DATABASE with FOR ATTACH_REBUILD_LOG, or remove the missing log in the SSMS Attach dialog. This tutorial builds a demo database, detaches it, and rebuilds the log on attach. It also explains when the rebuild is impossible and what to check afterward.
SQL SERVER – Fix Error – Cannot use the backup file because it was originally formatted with sector size 4096 and is now on a device with sector size 512
SSMS backup failed with ‘Cannot use the backup file because it was originally formatted with sector size 4096’. Here is why it happens and the easy fix.
SQL SERVER – Script level upgrade for database ‘master’ failed because upgrade step ‘upgrade_ucp_cmdw.sql’
After a cluster failover, SQL Server would not start on Node2 because upgrade step ‘upgrade_ucp_cmdw.sql’ failed. Here is what the ERRORLOG showed.
Listing Last Night’s Failed Agent Jobs With One msdb Query
List failed Agent jobs and steps from msdb history, include retries and cancellations, and account for local times and trimmed records.
Physical and Virtual Memory Explained for SQL Server DBAs
Physical and virtual memory are two different things, and SQL Server reports on both. This post explains RAM, address space, the page file and paging in plain words. It then reads each number with three read-only queries and ends with settings worth checking.
Does Dropping Primary Key Drop Non-Clustered Index on the Column? – Interview Question of the Week #085
Does dropping a primary key also drop the Non-Clustered Index on that column? An interview question with a small repro script to see the answer.
SQL Server slow? Let's fix it together in about four hours.
In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.
You keep every script, and the know-how to fix it yourself next time.
Want your whole team to learn it?
My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.
Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.