Archive | September, 2012
Had one of those days where I didn’t do anything stunningly impressive as every job seemed to be just some tinkering to fix other people’s problems.
But looking back on it the day has bee a great success as each one of the three problems lead to me revising some old skills or learning more about something I’ve not had to play with as much before hand
One of them was a classic developer’s SQL Server performace problem with parameter sniffing. One set of parameters pushed for a full scan and a spooled sort,
Nottingham based IT professional with over 15 years in the industry. Specialising in SQL Server, Infrastructure design, Disaster Recovery and Service Continuity management. Now happily probing the options the cloud provides
When not in front of a computer, is most likely to be found on the saddle of his bike
- SQL Server training opportunities, January and February 2014
- 10 days of Free SQL Server Training – SQL Relay 2013R2
- Disaster Recovery Basics: RPO – Recovery Point Objective
- Database slow to open after Instance restart or failover due to too many VLFs in transaction log.
- Hunting for select * with Extended Events