Congleton, Cheshire, England has The Beartown Tap (pb) which serves ales brewed locally by The Beartown Brewery.

Dunbar, East Lothian, Scotlan has The...

And another.

BoL often makes me...

Nice question.

But is there something wrong with the documentation? The BoL page referenced states

@@TRANCOUNT is incremented by one when entering a trigger, even when in autocommit...

Definitely after. Life gets...

Paul White NZ (10/3/2010)

Yes, they have confirmed SHA2 will be present in Denali:

http://connect.microsoft.com/SQLServer/feedback/details/585006/improve-hashing-support-hashbytes-improvements

For the time being we have SQLCLR...

Today I wanted to fnd out where hashbytes has got to in 2008 R2, so I looked it up (http://msdn.microsoft.com/en-us/library/ms174415.aspx).

I was appalled by what I found - the hashbytes function...

The chosen answer is wrong, the right answer is "it depends". The whole point of the "For Update" mark on a cursor declaration is to ensire that ITU locks...

I fell into the same trap as a couple of others: I assumed that "default" meant that the system would supply that extension as a default, so I left out...

Good question.

I was in two minds whether to tick "certificates" or not: after all, Server Level principals like ##MS_PolicySigningCertificate##, ##MS_PolicyEventProcessingLogin##, and so on are certificate derived, some even...

I wonder why MS decided to make Express a bit clunky by default.

Why should you expect dropping the snapshot and recreating it to work if you don't allocate some extra space for it? Surely it will just run out of space...

The answer is slightly wrong, in that the log reader agent doesn't look at the logs of all databases configured for transactional replication, it only looks at the logs of...

Nice clean question and nice clean answer.

I think the "policy stored in XML file" thing is a complete red herring - if the policy isn't in MSDB it isn't a...

Nice question, Nice clear explanation.

The concept of something that happens "on demand" is automated is somehat amazing, but 37% of replies chose that bizarre concept.