Archives: May 2011
I blogged a week ago about the sessions that I submitted for the PASS Summit this year. At the point that I scheduled the post I hadn’t seen the announcement from PASS, hence a second post on the same topic.
This year, you can vote for sessions that you want… Read more
Do errors encountered within a transaction result in a rollback?
It seems, at first, to be a simple question with an obvious answer. Transactions are supposed to be atomic, either the entire transaction completes or none of it completes.
Maybe too simple…
CREATE TABLE TestingTransactionRollbacks ( ID INT NOT NULL…
I missed the Pass summit last November for a number of reasons, but I’m hoping I can attend this year. Given that, I submitted a number of abstracts for consideration.
The limits on number were as follows: Up to 4 abstracts for regular, spotlight or half-day sessions (ie main conference… Read more
The virtual sessions were very popular, we don’t get many good international speakers down in our part of the… Read more
All of the indexing strategy posts I’ve written in the past have been concerned with predicates combined with ANDs. That’s only one half of the possibilities though. There’s the case of predicates combines with ORs, and the guidelines for indexing that work well with ANDs don’t work with ORs
When… Read more
From Tom LaRock’s latest idea…
For a change I’m not going to mention performance (well, not more than once anyway) and I’m not going to preach backups or recoverability. Nor am I going to talk about technical issues like many others are doing.
Instead I’m going to briefly mention… Read more