November 2010 - Posts

• API Server Cursors and related system Cursor stored procedures

  Every now and then, one encounters a legacy application that uses the API Server Cursors(see http://msdn.microsoft.com/en-us/library/ms187088.aspx ) or Cursor Stored Procedures http://msdn.microsoft.com/en-us/library/ms187801.aspx . In Profiler or Trace, Read More... Posted Friday, November 19, 2010 1:07 PM by jchang | 2 Comments Filed under: cursors

• NY Times The Great Cyberheist

  I pretty much stick to performance related issues and know very little of security, except that I prefer to enforce security at the boundaries instead of on the SQL Server itself. Its just after 5pm, and I came across this article, which eventually leads Read More... Posted Monday, November 15, 2010 6:43 PM by jchang | 0 Comments

• Add 54 new indexes to a table that already has 22 indexes

  This was the recommendation given by Micrsoft CSS (formerly PSS), along with 200 new indexes on other tables, in response to a case filed by a local company. The new index list was basically the output of the query from Bart Duncan’s blog " Are you using Read More... Posted Monday, November 08, 2010 10:53 AM by jchang | 0 Comments Filed under: Missing Index DMV