I currently type at a speed of around 50 words a minute and an error rate of about 4%. That isn't too bad, but I hate the constant backspacing I feel I am doing. I went looking for some online typing tutors... they are all pretty boring. Some fun online typing games though can be found at http://2addicted.com/words and http://2addicted.com/letters
Wednesday, May 10, 2006
Tuesday, May 09, 2006
Just incase this is valuable to anyone else, here is a script to change the logical file names in an mssql database.
declare @n1 varchar(100)
select @n1 = name from sysfiles where name not like '%_log%'
declare @n2 varchar(100)
select @n2 = name from sysfiles where name like '%_log%'
exec ('ALTER DATABASE [Test] modify file (NAME =''' + @n1 + ''', NEWNAME = ''Test_Data'')')
exec ('ALTER DATABASE [Test] modify file (NAME =''' + @n2 + ''', NEWNAME = ''Test_Log'')')
select name from sysfiles -- just to check
- 'Test' is the database name
- You have two files
- The log one ends in _log
- The other one doesn't