Notes on SQL

Random articles from a puzzled DBA

No. Well, that was easy – I should write more articles that succinctly. Although the real answer, is of course – it depends. Background I frequently come across the assertion that the Bulk Insert method is always minimally logged. It certainly can be but requires certain conditions to do so. I’ve decided to demonstrate the …

Continue reading

Introduction Binary Large Objects (BLOB) data can be a graphical image, a pdf document, a music file or any of a wide range of data types, which can generally be saved into a SQL Server database. As part of a series of investigations I’m currently performing within SQL Server, I have looked at how BLOB …

Continue reading

Introduction In a previous article article, I wrote about how to find out where the SQL Server error log is located. That particular article was in case your server instance did not start and you needed more information. If your SQL Server instance is working, there is another way to find the location of the …

Continue reading