SERIALIZABLE isolation level (serialized transactions) and duplicate key insertion attempts

I ran into an interesting scenario with a customer this past week that behaved a bit differently than I expected (not having ever verified the behavior before, or even considering it I guess) at first. After spending some time thinking about it, I think I arrived at a reasonable explanation for the behavior… In this…

0

Non-Unique Clustered Index and Duplicate Value limits…

I spent this past week with a customer giving a workshop covering Sql 2000 architecture and performance related information (interpreting query plans, index structures, etc., etc.), and during the course of the week a few good points came to light that I decided to blog about.  This first one has to do with the creation…

1

Tracking index maintanence information…

Similar to my post here (http://blogs.msdn.com/chadboyd/archive/2007/03/11/what-indexes-are-used-most-often-or-least-often-on-my-server.aspx) regarding index usage, you can use the following code below to get index operational information (exposed via the sys.dm_db_index_operational_stats dynamic management function in Sql 2005).  You can include table filters, specify ordering operations, and specify specific row numbers…correlate this information with other data from the usage data, missing index…

1

CMAP CodeCamp in Baltimore Area

Well, I’m now also presenting at the CMAP Code Camp the week following the NOVA CodeCamp, so, if you’re in the Baltimore/DC area (or even NOVA and can’t make the NOVA CodeCamp the week before), I’ll be presenting at least the same 2 sessions at the CMAP CodeCamp on April 21st at the UMBC Tech Center in…

0