SQL Server Best Practices

We’ve just published a whole bunch of SQL Server best practices here http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/default.mspx.  There’s some really great information on there and links to whitepaper resources.  I’ll certainly be bookmarking this for future reference. 

PerformancePoint Server 2007 CTP1 now available

PerformancePoint Server 2007 CTP1 is now available via the Connect website https://connect.microsoft.com/site/sitehome.aspx?SiteID=181.  The bits (x86 and x64) are available to download including documentation and sample data etc.  I haven’t had a change to look at it yet but will do over the next few days.  On a slightly different note, my brother has decided to run in the London Marathon…


Tempdb on RAM disks, Solid State?

This is quite an interesting KB article detailing I/O requirements for tempdb, and amongst other things, the use of RAM disks and solid state media.  There are some important points to consider e.g. as the media is not durable, only tempdb can be located on it; it cannot be used for other database files.  It is also worth remembering that the…

Win a copy of MSDN Team Subscription

Tony Rogerson (SQL Server MVP who runs the UK site sqlserverfaq.com) has two copies (invitations) of MSDN Team Subscription to give away!  Go here to read the full competition details: http://sqlblogcasts.com/blogs/tonyrogerson/archive/2006/11/11/1285.aspx What do you need to do?  Simple really, just contribute technical information, hints and tips or advice to the SQL Server community via the UK SQL Server User Group…

Sysinternal Utilities on TechNet!

The sysinternal tools are now on TechNet.  I know this is not specifically related to SQL Server however, but they are very useful tools which can help diagnose performance problems.   I particularly like process explorer and process monitor (and they work on x64 & Vista too!).  Get them here: http://www.microsoft.com/technet/sysinternals/processesandthreadsutilities.mspx


Using vardecimal storage in SQL Server 2005 SP2 CTP2

As you probably know, Service Pack 2 for SQL Server 2005 introduces the vardecimal storage format.  Below is a step-by-step example using the AdventureWorks database.  There are a few incorrections in BOL SP2 CTP2 although these are not major problems and can be easily resolved; I imagine discussions are ongoing about naming conventions for the vardecimal options.  USE master…


SQL Server 2005 Service Pack 2 CTP 2

The Service Pack 2 CTP 2 download will be available very soon from here: http://www.microsoft.com/sql/ctp.mspx. In the meantime, please take a look at the What’s New readme document which is available here: http://go.microsoft.com/fwlink/?LinkId=71711.   This provides a comprehensive review of the new and improved features.  I particularly like the fact that SSIS is no longer required for maintenance plans.  The…

Finding the NTFS Sector Size via DBCC

You can determine the formatted sector size of the database using DBCC FILEHEADER (‘<dbname>’).  The DBCC command actually returns quite a lot of information but we are only interested in the sector size column.  


SQL Server 2005 Service Pack 2 required for Longhorn & Vista

In case you were wondering, Longhorn & Vista will only support SQL Server 2005 Service Pack 2. This should be out as a Community Technology Preview (CTP) build sometime soon (I’ll blog about the forthcoming changes once we have publicly announced the CTP details). A more detailed explanation on SQL Support for Longhorn & Vista is posted here: http://www.microsoft.com/sql/howtobuy/sqlonvista.mspx