Author: Thomas LaRock

HOW TO: Improve Database Performance Without Changing Code

I’ve stated before that great database performance starts with great database design. So, if you want a great database design you must find someone with great database experience. But where does a person get such experience?We already know that great judgment comes from great experience, and great experience comes from...

Announcing the IS [NOT] NULL Newsletter

Today I want to officially announce the IS [NOT] NULL newsletter.You may have seen me mention the IS [NOT] NULL newsletter on Twitter and Facebook in previous weeks but today I want to show off the shiny new landing page, built by the Business Betties.I've mentioned before that this blog...

Lost Data

DBAs get paid for performance but we keep our jobs with recovery.Being able to recover data is the most important job function you have as a DBA.  If you can't recover your data because database backups are missing, or corrupt, then you should consider a new line of work.The year is...

how to recreate sql server statistics in a different environment
HOW TO: Recreate SQL Server Statistics In a Different Environment

Did you know table and index statistics are the most important piece of metadata for your database?The reason for this has to do with how SQL Server (and other database engines) build query execution plans. The query optimizer builds an execution plan based upon the statistical data available at the...