Tag : DBA

pgSQL vs T-SQL – Database Shrinking to reclaim space for the OS

Databases typically grow over time. One occasion where they may counter that trend is if obsolete data is permanently removed. In Postgres, Dropping or Truncating a table does clear its data file on disk (see $PGDATA/base/YourDbOID/ ). However in SQL Server it doesn’t. Nor does running a regular VACUUM in Postgres following bloat introduced from Updates and Deletes. Internally, the…

SQLIO

You’ve spent thousands on a shiny new server. Before you go ahead and configure your database environment, now is a good time to tune the software side of your storage subsystem for optimal performance. SQLIO is a Command Line IO benchmarking utility for Windows which can help you do just that. For Linux, consider utilities such as fio or bonnie++.…

Missing Sql Server Startup parameters

I once came across an issue with a local SQL Server instance that refused to start on my laptop. The Windows Event viewer reported ‘initerrlog: Could not open error log file ”. Operating system error = 3(The system cannot find the path specified.).‘ At the time I searched around on the net but couldn’t find any thing quick so I…