SQL DBA Blog: Home
-
View the Definition of a Stored Procedure in SQL Server
Three ways to read the source of a stored procedure, and the trap in all of them: without VIEW DEFINITION, OBJECT_DEFINITION returns NULL rather than an error, which looks exactly like the procedure does not exist.
-
TempDB Is Full or Still Growing: Find What Is Using It, Right Now
TempDB belongs to the whole instance, so the question is never whether it is full, it is which session filled it. One query names the session, and user objects, internal objects and the version store each end a different way.
-
SQL Server Service Will Not Start: Error 17113, 17058, 1067 and Where the Real Reason Is
The service will not come up and Windows only says 1067. Where the real reason lives, what errors 17113 and 17058 are actually telling you, and what to do when the log says nothing at all.
-
How to Move TempDB Files in SQL Server
TempDB on the C: drive is a problem waiting for a busy day. It can grow very large, very quickly, sometimes within minutes under the right workload, and when it fills the OS drive it takes the whole server down with it. Moving the tempdb files to their own drive is a standard best practice,…
-
RAND() vs NEWID() in SQL Server
Most people searching for “random numbers in SQL Server” want one of two things: SQL Server gives you two common tools for this: RAND() and NEWID(). They solve different problems, and confusion usually starts when they are treated as interchangeable. This post shows how to use both, starting with simple examples, and explains why they…
-
SQL Server Error 3906: Writes Fail Because the Database Is Read-Only
Msg 3906 means SQL Server considers the target database read-only. Check its state and recovery role before changing it. A log-shipping secondary may be read-only by design.
-
RESTORE VERIFYONLY Fails: Reached the End of the File (Error 3203)
RESTORE VERIFYONLY returned Msg 3203 on a truncated backup in this HPAI01 test. The header was readable, but the file was incomplete. Direct RESTORE returned Msg 3287 instead.
-
SQL Server Is Slow: What to Check First, in Order
A symptom router for the slow SQL Server call. One check per step, in the order that finds the fault fastest, each handing off to the post that owns it.
-
SQL Server Backup Failed or the Restore Is Stuck
Three incidents that look alike and share nothing: a BACKUP that failed, a RESTORE that failed, and a restore that is still running. This page routes each one to the post that owns it.
-
SQL Server Disk Is Full or the Log Will Not Truncate
A routing page for every out of space incident on SQL Server: which drive, which file, what log_reuse_wait_desc is telling you, and why shrinking comes last.
- View the Definition of a Stored Procedure in SQL Server
- TempDB Is Full or Still Growing: Find What Is Using It, Right Now
- SQL Server Service Will Not Start: Error 17113, 17058, 1067 and Where the Real Reason Is
- How to Move TempDB Files in SQL Server
- RAND() vs NEWID() in SQL Server
- SQL Server Error 3906: Writes Fail Because the Database Is Read-Only
- Backups & Recovery (17)
- DBA Scripts (151)
- High Availability (HA) (12)
- Installation & Configuration (49)
- Maintenance (25)
- Migration & Upgrades (14)
- Monitoring (9)
- Performance Tuning (37)
- Security (Encryption & Permissions) (19)
- Storage & Capacity (16)
- T-SQL Fundamentals (15)
- Troubleshooting (94)
- Wait Types (235)