Well done the BBC for finally making approx. 100 video clips from its archive available via the Creative Commons License. The only downside is that it is just that - video but with no audio. My guess is that they have had to take this approach because they cannot resolve the rights issues for music and voice overs used in the programme material that the clips are derived from?
Wednesday, August 24, 2005
Tuesday, August 23, 2005
Monday, August 22, 2005
Sunday early pm was spent seeing a perfomance of Switch Triptych. Maybe I'm getting a liitle old but the first 15 minutes were hard work, you really had to want this performance to work for you; there were a few walkers. The fact that the main character'e lines were hardly discernable was really the problem.
Saturday, August 20, 2005
Thursday, August 18, 2005
It's festival time here in Edinburgh and this evening we went to see a performance of All Wear Bowlers;an enjoyable, clever and funny update on vaudeville and music hall acts from 80 or more years ago. God damn, these East Coast theatrical types are sharp for mark.
Friday, August 12, 2005
An interesting snippet. According to a new study of peer-to-peer networking by Cachelogic, 12.3% of audio files swapped over the network are in OGG format. MP3 still accounts for 68.9% though. The BBC has a commentary on the report.
Wednesday, August 3, 2005
Alouette par radio est actuellement mon favori écoutent sur la liste de l'aacPlus d'Orban. Appréciez !
We came across this recently when we tried to delete a database and found that the server was churning away for hours at > 50% on each CPU. As Andrew's article explains this is because the backuphistory table in msdb is never cleared out - ours had > 250K rows and hence the load when sp_delete_backuphistory is called when a database is deleted!
If you have lots of databases that are backed up and hence a large table - like ours - you really want to step through a month at a time.
declare @xtime datetime
set @xtime = cast('04/01/2003' as datetime)
use msdb
exec sp_delete_backuphistory @xtime;
Once you have it cleared out then you probably want to add a nightly job to clean it up. Add something like the following procedure to to msdb:
create procedure TidyBackupHistoryTo60Days
as
-- delete backup entries older than 60 days
-- run as nightly job to keep msdb tidy
-- procedure must be stored in msdb as it uses
-- sp_delete_backuphistory which is defined there
begin
declare @xtime as datetime
set @xtime = dateadd(d,-60,getdate())
exec sp_delete_backuphistory @xtime
end
If you have lots of databases that are backed up and hence a large table - like ours - you really want to step through a month at a time.
declare @xtime datetime
set @xtime = cast('04/01/2003' as datetime)
use msdb
exec sp_delete_backuphistory @xtime;
Once you have it cleared out then you probably want to add a nightly job to clean it up. Add something like the following procedure to to msdb:
create procedure TidyBackupHistoryTo60Days
as
-- delete backup entries older than 60 days
-- run as nightly job to keep msdb tidy
-- procedure must be stored in msdb as it uses
-- sp_delete_backuphistory which is defined there
begin
declare @xtime as datetime
set @xtime = dateadd(d,-60,getdate())
exec sp_delete_backuphistory @xtime
end
Subscribe to:
Comments (Atom)