tag:blogger.com,1999:blog-40612227181170762022011-04-21T13:48:09.938-07:00What time is it? It's Geekazoid time......Mark Pryce-Mahernoreply@blogger.comBlogger51100tag:blogger.com,1999:blog-4061222718117076202.post-49494890337814145832007-12-18T06:34:00.000-08:002007-12-18T06:37:44.319-08:00I was sent this review of Windows XP; about someone upgrading from Vista to XP... Have a read...<br /><br />"I have finally decided to take the plunge. Last night I upgraded my Vista desktop machine to Windows XP..."<br /><br /><a href="http://dotnet.org.za/codingsanity/archive/2007/12/14/review-windows-xp.aspx">http://dotnet.org.za/codingsanity/archive/2007/12/14/review-windows-xp.aspx</a><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/4061222718117076202-4949489033781414583?l=geekoclock.blogspot.com' alt='' /></div>Mark Pryce-Mahernoreply@blogger.com0tag:blogger.com,1999:blog-4061222718117076202.post-74523675267247876622007-12-18T04:51:00.000-08:002007-12-18T05:34:57.324-08:00<p><span style="font-family:arial;font-size:130%;">How to shrink a SQL Server transaction log file.</span></p><p><span style="font-family:arial;">It always happens when you least expect it, your application starts to go mental (if you are luckly) sometimes your server just crashes.</span></p><p><span style="font-family:arial;">What could it be? Your SQL Server transaction log file has eaten up your entire hard disk and you are now stuck. <br /><br />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.<br /><br />To get your application (your SQL Server) back up and running, run the follow SQL.<br /><br /><strong>dump transaction <<em>DBNAME</em>> with no_log</strong><br /><br />then<br /><br /><strong>DBCC SHRINKFILE(<<em>LOG FILE LOGICAL FILE NAME</em>>,2)</strong><br /><br /><br />References:<br /><span style="font-size:85%;">INF: Shrinking the Transaction Log in SQL Server 2000 with DBCC SHRINKFILE (</span></span><a href="http://support.microsoft.com/kb/272318/"><span style="font-family:arial;font-size:85%;">http://support.microsoft.com/kb/272318/</span></a><span style="font-family:arial;font-size:85%;">)<br /><br />INF: Transaction Log Still Full After DUMP TRAN WITH NO_LOG (</span><a href="http://support.microsoft.com/kb/184499"><span style="font-family:arial;font-size:85%;">http://support.microsoft.com/kb/184499</span></a><span style="font-family:arial;font-size:85%;">)</span></p><span style="font-family:arial;"></span><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/4061222718117076202-7452367526724787662?l=geekoclock.blogspot.com' alt='' /></div>Mark Pryce-Mahernoreply@blogger.com0tag:blogger.com,1999:blog-4061222718117076202.post-38611091620481618762007-12-07T06:43:00.000-08:002007-12-07T06:47:04.374-08:00<a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://www.dabs.com/images/product/uni2/4r/4rws_large.jpg"><img style="margin: 0pt 0pt 10px 10px; float: right; cursor: pointer; width: 200px;" src="http://www.dabs.com/images/product/uni2/4r/4rws_large.jpg" alt="" border="0" /></a><br />What a bargin!!<br /><p>AMILO Li 1818</p> <p>Intel Pentium Dual-core T2130 2.0GHz</p> <p>2048MB DDR2 SDRAM Memory</p> <p>160 GB SATA HDD</p> <p>17" WXGA+ 1440x900 Widescreen</p> <p>DVD±RW Dual Layer</p> <p>Integrated IEEE 802.11 a/b/g</p> <p>4 cell Li-Ion Battery</p> <p>Microsoft Windows Vista Home Premium Edition DVD burning Software, Norton Symantec Internet Security Suite (90 day trial)</p> <p>1 Year UK Warranty Courier Collect and Return</p><br /><p>All for £448.99 from Dabs.<br /></p><br />http://www.dabs.com/productview.aspx?Quicklinx=4RWS<div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/4061222718117076202-3861109162048161876?l=geekoclock.blogspot.com' alt='' /></div>Mark Pryce-Mahernoreply@blogger.com1tag:blogger.com,1999:blog-4061222718117076202.post-88375522928542959862007-08-10T06:04:00.000-07:002007-08-10T06:06:07.297-07:00Jon from work has started a new blog, what a catchy title....<br /> <a href="http://trioxin.wordpress.com/">devouring the flesh of the living</a><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/4061222718117076202-8837552292854295986?l=geekoclock.blogspot.com' alt='' /></div>Mark Pryce-Mahernoreply@blogger.com1tag:blogger.com,1999:blog-4061222718117076202.post-79501117636571609832007-08-08T05:04:00.000-07:002007-08-08T05:46:27.456-07:00I've got one blog at the moment that contains all my personal and geek related stuff.<br /><br />It feels a bit of a mess having them together, so I've split them out.<br /><br /><a href="http://markpm.blogspot.com/">Markpm.blogspot.com</a> is now my personal blog (which consists mainly of pictures of Tabby) and<br /><a href="http://geekoclock.blogspot.com/">GeekOClock.blogspot.com</a> is my geeky one.<br /><a href="http://googlesearchwithimages.blogspot.com/">googlesearchwithimages.blogspot.com</a> is a Search Page I've been playing with.<br /><br />So first things first, I've added links to my <a href="http://www.codeproject.com/script/articles/list_articles.asp?userid=3160414">CodeProject articles</a>.<div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/4061222718117076202-7950111763657160983?l=geekoclock.blogspot.com' alt='' /></div>Mark Pryce-Mahernoreply@blogger.com0