July 2007 - Posts

• Which DMV Shows Plan Handles?

  Sometimes, knowing which Dynamic Management View (DMV) to use is your biggest challenge when attempting to figure out SQL Server 2005 behavior. For example, what if you want the cached execution plans in XML format, similar to the output of SET SHOWPLAN_XML? Read More... Posted Wednesday, July 25, 2007 5:02 PM by KKline | 0 Comments Filed under: SQL Programming, Internals

• Who's more secure, Oracle or SQL Server?

  UK SQL Server MVP Jasper Smith pointed out a really useful resource if you work with or are concerned about both Oracle and SQL Server. The white paper, by David Litchfield of NGS Software, comparesthe numbers of security flaws identified by external Read More... Posted Wednesday, July 18, 2007 4:52 PM by KKline | 1 Comments Filed under: Interoperability

• Tracking Log File Growth on SQL Server 2000

  Gert Drapers , whom I consider to be a super-genius of the SQL Server world and owner of the very useful website http://www.sqldev.net , wrote a useful little script a few years ago that I thought I'd share. This is a SQL query that will show who and Read More... Posted Wednesday, July 11, 2007 4:37 PM by KKline | 1 Comments Filed under: SQL Programming

• Corrections on Trace Flag Entry

  Kalen Delaney and I were chatting via email about a past blog entry I'd written about trace flags. http://www.sqlmag.com/Article/ArticleID/92774/Trace_Flag_Changes_in_SQL_Server_2005.html The blog entry was based on some discussions I'd listened in on Read More... Posted Wednesday, July 04, 2007 3:15 AM by KKline | 0 Comments Filed under: Internals, People