September 2007 - Posts
Lots of useful info appearing here http://sqlcat.com/Default.aspx . This is a great article on database mirroring log compression in Katmai http://sqlcat.com/technicalnotes/archive/2007/09/17/database-mirroring-log-compression-in-sql-server-2008-improves-throughput.asp
Read More...
This is a nice touch, the pre-canned VHD's are now available for pre-release versions of SQL Server 2008 CTP4 http://www.microsoft.com/downloads/details.aspx?FamilyID=6a39affa-db6e-48a9-82e4-4efd6705f4a6&DisplayLang=en and Windows Server 2008 Beta
Read More...
I thought the SQL Server 2005 Large Values out of Row would be a sp_tableoption config value similar to text in row - apparently not! It took a while to find out that this is hidden in sys.tables. The following query returns the value I was
Read More...
The PPS UK launch is happening on 16th October in London. Sign up here: http://www.microsoft.com/uk/office/ppslaunch/default.mspx
Read More...