Yesterday I noticed that a number of pages were rendering rather badly. The problem stems from modifying the blog to allow me to write and publish in markdown using Text Mate.
I thought the plugin would convert the markdown to html when it was published, it actually renders the html from markdown when the page [...]
And there I was prepared to accept an inferior, thunder class, analysis product.
I’m trying to study for the next MS SQL Server 2005 exam and keep getting annoyed by practice questions that are wrong. The latest one to bother me was this statement in one of the answers:
“Both read committed snapshot isolation and snapshot isolation can produce phantom records.”
Wikipedia has a nice definition of the problem of [...]
In a previous post I spent some time looking at which ports are used by SQL Server 2005 including what port the Dedicated Administrator Connection uses. At the time it looked like it was possible to connect to the DAC for a server without the SQL Browser service running.
Since then as I’ve been studying [...]
Time to take a look at the performance of the queries I wrote when looking at the new TSQL clauses EXCEPT and INTERSECT in SQL Server 2005.
EXCEPT query performance
Lets start with query 3, the query that used EXCEPT and had the highest performance. Here’s the xml sqlplan, I’ve altered the original SQL slightly to [...]