If I’ve said it once, I’ve said it 1,024 times: your SQL data and log drives need a 1024 KB starting offset, and a 64 KB block size*. Your SQL data and log drives need a 1024 KB starting offset, and a 64 KB block size. If you read this blog, you’re likely a data professional. […]
Category: Admin
GetLogSpace – table and stored procedure
We’ve talked before about how to get log space usage information in SQL Server. After the 1,032nd time I re-wrote my custom query to also see the UNused log space, it occurs to me that this would be a nice thing to have on your server on a permanent basis. Introducing: GetLogSpace! It’s a simple […]
The case for SQL Server 2012 Enterprise (vs. Standard) edition
In celebration of the impending SQL Server 2014 release, and in recognition that a large percentage of my clients are on that cusp of the Standard/Enterprise licensing decision for the currently available version…let’s talk about SQL Server 2012! Specifically, why Enterprise edition might be a huge advantage – or even an imperative – for your shop. […]