Alfred's New Ramblings


SQL Express 2008

This is the first time I used SQL Server 2008 Express.  A most interesting experience.  First off there are several types, database only, management tools only, both  and Advanced Services that comes with reporting services.  I installed the database only…

How wide is it?

I was tooling around Microsoft SQL server in preparation for a 64 bit migration when I came across this interesting command. xp_msver It returned the following for my Intel box. 1    ProductName    NULL    Microsoft SQL Server 2    ProductVersion    589824    9.00.4035.00…

SQL Server migration

The databases on a sql server are located in the Data directory.  This is usually located on a non system partition.  So that database growth will not affect system stability.  What happens you got a new spanking SAN?