Tag Archives: Query

Scottish Power Economy 7 Rates and The Owl SQLite Queries

Posted by dave on June 14, 2012 No comments

In a previous post I talked about querying data from The Owl SQLite database, and here I will advance on that a little. I’ve also recently made some changes to my home network after upgrading to Virgin’s Superhub and 60Mb …

Read more »

Speeding up MySQL Databases by setting the Query Cache Size

Posted by dave on February 11, 2011 No comments

I use MySQL in a Windows Server 2008 R2 box and it runs very well, I never have any issues with it and currently there are about 18 databases on there. However, it now has a fair bit of data …

Read more »

Useful MS SQL Code Snippets

Posted by dave on April 19, 2010 No comments

I figured this was a good place to put and SQL code that I sometimesuse. I’ll document it a bit later on, its all pretty straight forward   SET DATEFIRST 1SELECT CASE WHEN DATEPART(WEEKDAY,GETDATE()) =  1 THEN columname1 WHEN DATEPART(WEEKDAY,GETDATE()) …

Read more »