September 2006 - Posts

• Metadata Power

  I love the new catalog views and DMVs in SQL Server 2005, and I have written quite a few of my own views on top of them, to give me more specific information that I need. However, many of the views contain object_id information, and I would much rather Read More... Posted Sunday, September 24, 2006 9:01 PM by Kalen Delaney | 4 Comments

• Cost of Scalar Functions

  While Adam was living it up at VSLive in New York last week, I was consulting in Atlanta, trying to find way to make an application 'run faster'. I won't go into the gory details of everything I looked at, but one there is one aspect of the system I'll Read More... Posted Sunday, September 17, 2006 2:51 PM by Kalen Delaney | 7 Comments Attachment(s): test function calls.txt

• Did you know? -- New Deadlock Priorities

  Back in SQL Server 2000, and all previous versions, the set option SET DEADLOCK_PRIORITY had 2 values, LOW and NORMAL, and LOW did not mean that you had lower priority for being selected the victim. Setting this option to LOW was like setting the martyr Read More... Posted Saturday, September 09, 2006 9:06 AM by Kalen Delaney | 16 Comments

• Did you know? -- Syntax relaxation

  One of the things I want to use this blog for is to post details of system changes that are not well publicized, some of which I only learn about accidentally. In SQL 2000, the first time I saw this strange syntax to use :: to specify a system defined, Read More... Posted Wednesday, September 06, 2006 2:34 PM by Kalen Delaney | 4 Comments

• Inside SQL Server... the book

  I finished the actual writing of my Storage Engine volume today. I thought that would be good fodder for my first blog entry. Inside SQL Server 2005: The Storage Engine is now done. The last chapter was done a few weeks ago, but I still had to write front Read More... Posted Wednesday, September 06, 2006 11:42 AM by Kalen Delaney | 9 Comments