Review: Windows XP

I was sent this review of Windows XP; about someone upgrading from Vista to XP... Have a read...

"I have finally decided to take the plunge. Last night I upgraded my Vista desktop machine to Windows XP..."

http://dotnet.org.za/codingsanity/archive/2007/12/14/review-windows-xp.aspx

Honey, I shrank the log file.

How to shrink a SQL Server transaction log file.

It always happens when you least expect it, your application starts to go mental (if you are luckly) sometimes your server just crashes.

What could it be? Your SQL Server transaction log file has eaten up your entire hard disk and you are now stuck.

It’s too big to move and you don’t have any space to do a backup because the log file is using up all the space.

To get your application (your SQL Server) back up and running, run the follow SQL.

dump transaction <DBNAME> with no_log

then

DBCC SHRINKFILE(<LOG FILE LOGICAL FILE NAME>,2)


References:
INF: Shrinking the Transaction Log in SQL Server 2000 with DBCC SHRINKFILE (http://support.microsoft.com/kb/272318/)

INF: Transaction Log Still Full After DUMP TRAN WITH NO_LOG (http://support.microsoft.com/kb/184499)

Fujitsu Siemens Li1818 Dual Core 2GB 160GB DVD±RW 17inch Screen Vista Home Premium Laptop

What a bargin!!

AMILO Li 1818

Intel Pentium Dual-core T2130 2.0GHz

2048MB DDR2 SDRAM Memory

160 GB SATA HDD

17" WXGA+ 1440x900 Widescreen

DVD±RW Dual Layer

Integrated IEEE 802.11 a/b/g

4 cell Li-Ion Battery

Microsoft Windows Vista Home Premium Edition DVD burning Software, Norton Symantec Internet Security Suite (90 day trial)

1 Year UK Warranty Courier Collect and Return

All for £448.99 from Dabs.

http://www.dabs.com/productview.aspx?Quicklinx=4RWS

devouring the flesh of the living

Jon from work has started a new blog, what a catchy title....
devouring the flesh of the living

Welcome to my Geekdom..

I've got one blog at the moment that contains all my personal and geek related stuff.

It feels a bit of a mess having them together, so I've split them out.

Markpm.blogspot.com is now my personal blog (which consists mainly of pictures of Tabby) and
GeekOClock.blogspot.com is my geeky one.
googlesearchwithimages.blogspot.com is a Search Page I've been playing with.

So first things first, I've added links to my CodeProject articles.