The Smiling DBA
Archives: October 2012
When a Covering Index no longer covers
I received an email from my boss on the morning supervisors approve timesheets. He stated that they are complaining about an error: Deadlock. Searching the SQL Log, I was able to get the details of the deadlocking. We have Trace Flags 1204 and 1222 turned on which provides the details.… Read more
2 comments, 913 reads
Posted in The Smiling DBA on 14 October 2012
Part II - Louis Davidson (Dr SQL)–Designing for Common Problems in SQL Server…continued
The PASS Data Architecture Virtual Chapter will host part II of Designing for Common Problems in SQL Server by Dr. SQL Louis Davidson as he helps application and database developers design and implement SQL Server databases.
I saw Louis at the first PASS Summit I attended in Denver in 2006.… Read more
0 comments, 183 reads
Posted in The Smiling DBA on 9 October 2012



Subscribe to this blog