Last week I wrote a post on Isolation Levels and the Effects on Select Statements, and I had a conversation on Twitter with Rob Farley ( b | t ) regarding one of my explanations. For READ COMMITTED, I had written the following: If data is being modified by a transaction, any subsequent select statement…
Category Archives: SQLSequel
Statistics and Recompilations, Part II
I recently blogged about an interesting behavior in SQL Server when the database option, Auto Update Statistics, is disabled…and that post requires a sequel. The summary is that when you have the Auto Update Statistics option disabled for a database, query plans for tables are not recompiled when their statistics are updated. There is an…
Found: Rows from a Merge Join
About a month ago I blogged about an issue I had with a customer where a search in one area of our application returned less data than expected, and a search in a different area of the application returned the proper amount of data. I was able to work around the issue by dropping a…
Seek and ye shall find
When I was thinking up names for this blog, I had a hard time not using the name my husband uses for his fantasy baseball team: The Stellato Heels. It’s great, isn’t it? I can boast about how fabulous it is because I didn’t think of it. I had great visions for the logo. Just…
