Welcome to MSDN Blogs Sign in | Join | Help

Benjamin Wright-Jones

SQL Server Lessons Learned and Notes from the Field (Microsoft Consultancy Services, UK)

News

  • This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified on Microsoft.com Locations of visitors to this page

September 2007 - Posts

Finally, SQLCAT have a dedicated site
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...
SQL Server 2008 CTP 4 available as VHD
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...
How do I find out if Large Values out of Row is enabled?
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...
PerformancePoint Server 2007 UK Launch
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...
Page view tracker