Category Archives: SQLServerPedia Syndication

Content automatically syndicated to SQLServerPedia

Reading SQL Server Error Logs

Posted on August 16, 2019 by thomasrushton

I wrote a script to allow me to look at the last few days of errors in the SQL error logs. It was rather useful at a previous site, and I wrote them a little note about it, which I … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , | 14 Comments

DBCC DBINFO() – Don’t rely on undocumented commands

Posted on July 28, 2019 by thomasrushton

Don’t Rely on Undocumented Commands – A Cautionary Tale Looking at the output for the (undocumented) DBCC DBINFO() command, I noticed a typo in one of the field names. I wondered about submitting it as a bug, but then looked … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , | 3 Comments

SQL In The City – Summit – London, April 2019

Posted on April 24, 2019 by thomasrushton

Just a quick plug (no, I don’t get paid for this) for Redgate’s next SQL In The City “Summit” – a higher-end version of their SQL in the city events that they used to hold before they went online a … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , | Leave a comment

Failed to Update Read-Only Database on Backup

Posted on March 3, 2019 by thomasrushton

A problem at work recently – the Netbackup-driven SQL backups were failing for just one database on a particular server. The database in question was, like one other, set to read-only. I ran DBCC CHECKDB, on the off-chance that this … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , , , | 3 Comments

Redgate SQLPrompt – Backup your code snippets

Posted on January 15, 2019 by thomasrushton

You’ve got a new computer? And you want to copy your code snippets over? Or you’ve got a new colleague and want to share your stuff? Or you’ve got multiple machines an want to keep snippets in sync? You’ll want … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , | Leave a comment

Error: There is not enough space on the disk

Posted on December 2, 2018 by thomasrushton

I was running a query in SQL Server Management Studio (SSMS), nothing too complicated, and got this error, unexpectedly: An error occurred while executing batch. Error message is: There is not enough space on the disk. There’s plenty of space … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , | Leave a comment

OBJECT_ID()’s second parameter

Posted on October 30, 2018 by thomasrushton

I received a supplier-supplied maintenance / check / troubleshooting script that did a whole heap of looking-to see-if-a-default-value-exists-and-if-it-doesn’t-then=create-it type stuff. As you would expect, it’s a load of They could have saved themselves a bit of typing (or, let’s be … Continue reading →

Posted in SQLServerPedia Syndication | Tagged | Leave a comment

SQL Server Availability Groups and SQL Server Reporting Services – A Brief Rant Triggered By Someone Failing Something Over Without Understanding The Full Implications, Or, Pay Attention To Your DBA Because He Knows This Stuff And That’s What You Pay Him For

Posted on July 2, 2018 by thomasrushton

Is the headline longer than the body? Not now I’ve included the fix for this situation as well as the initial rant. Maybe next time. Yes, you may have an availability group – well done – and you may have … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , , | 3 Comments

SQL Server Error 18456 Severity: 14 State: 73

Posted on May 14, 2018 by thomasrushton

A question asked on one of the forums today wasn’t easily answerable by Googling. Summary of the question “I have error 18456 State 73 – why?” Google seemed remarkably quiet on the subject of that particular state code. Even Aaron … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , , | 1 Comment

Longrunning Query – xp_cmdshell?

Posted on April 25, 2018 by thomasrushton

Flicking through the ol’ Solarwinds activity monitor, I spotted this one day: That four day purple thing on the right? Not good. (The remaining images are from a reconstruction, partly to protect the not-so-innocent, and partly because the first job … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , , , , , | 1 Comment