30 Nov 2005

Visual Studio 2005 beta 2 breaks ASP.NET 2.0 application cache

Cut a long story short (again) - If you have an app running on your workstation that uses the web cache (e.g. HttpContext.Current.Cache) you may notice the cache contents being dropped at seemingly random intervals while developing the app in Visual Studio 2005 beta 2. The bizarre behaviour starts when I open an ASPX page for editing, and then only stops when I close Visual Studio.

21 Nov 2005

Physically Shrinking An SQL Server 2000 DB's Transaction Log File

Had a big old transaction log (LDF) file that I wanted to cut down to size after backup.

This was quick (but very dirty):

  1. Set Recovery mode to "Simple" in DB Properties > Options.
  2. Ran a CHECKPOINT command in Query Analyser
  3. Ran a DBCC SHRINKDATABASE() command in Query Analyser

18 Nov 2005

SQL Server 2000 Full-Text Indexing

Cut a long story short - You can't do Full-Text Indexing in SQL Server 2000 on Windows 2000 Professional edition.

Why it doesn't say this anywhere on the Microsoft site is beyond me. The enclosed link was the only one I could find to confirm why the "Full-Text Indexing" option in Enterprise Manager was greyed (grayed ?) out on my workstation.
If I helped you out today, you can buy me a beer below. Cheers!