March 2010 - Posts

18 March 2010
Have you really fixed that problem?
The day before yesterday I saw our main live server's CPU go up to constantly 100% with just the occasional short drop to a lower level. The exact opposite of what you'd want to see. We're log shipping every 15 minutes and part of that involves calling WinRAR to compress the log backups before... Read More...
no comments
Filed under: , ,
09 March 2010
Finding rows that intersect with a date period
This one is mainly a personal reminder but I hope it helps somebody else too. Let's say you have a table that covers something like currency exchange rates with columns for the start and end dates of the period each rate was applicable. Now you need to list the rates that applied during the year... Read More...
2 comment(s)
Filed under:
04 March 2010
Log shipping and shrinking transaction logs
I just solved a problem that had me worried for a bit. I'm log shipping from three primary servers to a single secondary server, and the transaction log disk on the secondary server was getting very full. I established that several primary databases had unused space that resulted from big, one-off... Read More...
2 comment(s)
Filed under: ,