Category Archives: SQLServerPedia Syndication

Content automatically syndicated to SQLServerPedia

Reading SQL Server Error Logs

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 , | 8 Comments

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

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

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

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 , , , | 2 Comments

Redgate SQLPrompt – Backup your code snippets

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

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

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