A faster CHECKDB – Part I

Earlier this year I travelled to Japan having the opportunity to visit some of our customers and prospective customers. One feedback I received loud and clear was poor performance when using DBCC CHECKDB as customers have moved into the TB range of databases on a regular basis. I had certainly heard this feedback before from…


Exporting via HTML instead of MHTML

There was a question on Twitter about how to display a report in HTML instead of MHTML due to some browser issues.  Based on the fact that it was MHTML, I’m assuming we are talking about exporting a report as the default report view is HTML.  First off, if we look at our export options…


Distributed Replay for SQL Server 2012

I recently had a lengthy exchange on DReplay with Jonathan Kehayias (SQL MVP).   From this exchange I filed several work items with the SQL Server development team to help install and setup DReplay easier in the future. Jonathan has started a series of blog posts on his experiences that I would only be copying to…


SQL Server: Clarifying The NUMA Configuration Information

The increased number of cores per socket is driving NUMA designs and in SQL Server support we are seeing more NUMA machines and less pure SMP machines.    For whatever reason over the past 2 weeks I have fielded a bunch of questions around NUMA and the information is good for everyone to know so I…


Error 1803 and model size change in SQL Server 2012

Recently I encountered error 1803 when working on SQL Server 2012. The script I ran against a SQL Server 2012 instance was CREATE DATABASE [suspect_db] ON  PRIMARY ( NAME = N’suspect_db’, FILENAME = N’C:Program FilesMicrosoft SQL ServerMSSQL11.SQL11_CTP3MSSQLDATAsuspect_db.mdf’ , SIZE = 2048KB , FILEGROWTH = 1024KB ) LOG ON ( NAME = N’suspect_db_log’, FILENAME = N’C:Program…


The week that was PASS 2011 & Moving on…

This is to recap my week at PASS Summit 2011.  This was my 4th US PASS, and every year it is amazing.  I really enjoy sharing information with the community as well as getting to meet the people I talk to on Twitter and in other areas.  Between Technical and Social Networking, this really is…


Easy JDBC Logging

I have been supporting Microsoft’s JDBC driver for almost six years now and the one thing with which I always struggle is getting logging going.  JDBC logging is probably some of the most useful logging out there (I only wish BID tracing were so easy to enable and consume!), but for some reason I always…


A Better solution for the Windows 7 SP1 ADO GUID changes

UPDATE:  This fix was published in mid-February as http://support.microsoft.com/kb/2640696.  We are still working on fine-tuning all of the documentation so that everything points to the appropriate places, but the binaries are already available.  The fixes for Windows 7 and Windows 2008 R2 and publically available.  Fixes for other OSes are also available, but you will…


After Applying SQL Server 2008 R2 SP1 Error 9013 is logged (The tail of the log for database %ls is being rewritten to match the new sector size of %d bytes …)

In SQL Server 2008 R2 SP1 we made updates to dynamically accommodate disk drives that present physical sector sizes greater than 512 bytes.   In practice, these are generally 4K, physical sector size drives and the SQL 2008 R2 transaction log code will dynamically adjust to the presented physical sector size to accommodate various sector configurations….