Slight nit-picking issue: what is a "courser" lock? Do you mean a coarser lock?

http://dictionary.reference.com/browse/Courser

http://dictionary.reference.com/browse/Coarser

You could also use single-user mode from the command-line, even if BUILTIN\Administrators is not in the sysadmin role:

http://dba.stackexchange.com/a/11302

One small issue - there is no "C#.NET"; it's just called "C#".

VB gained the ".NET" suffix to differentiate it from the pre-.NET versions, but C# was created at the same...

So a man who runs a company which sells a competitor to "oldSQL" products has given an interview saying the "oldSQL" is bad, and his "newSQL" competitor is doubleplusgood?

OK, I'll...

Some suggestions: 🙂

[font="Courier New"]if (URI.IsNull == true)[/font]

The IsNull property is a boolean, so this should be: "if (URI.IsNull)".

[font="Courier New"]URI.ToString().TrimStart().TrimEnd().Length < 1[/font]

Or, as it's known in .NET, ".ToString().Trim().Length == 0". You've...

Nice article.

It makes me wonder why 64-bit SQL can't use 32-bit providers (eg Jet), since the bit-ness of out-of-process COM components doesn't matter. They'd only need a 32-bit host...

Am I the only one who was expecting a request for "four candles"? 😛

But if you're going to do that, wouldn't it...

How can anyone claim that storing a date as the string "09/01/2001" is better...

Sorry to resurrect an old thread, but it looks like I was right all along: 🙁

Red Gate will be charging $35 for .NET Reflector

---

Red Gate has announced that it will...

Nice easy question? Unless I'm missing something, the CREATE TABLE, the first INSERT, the BEGIN TRAN and the ALTER TABLE statements are all inside a stored procedure which is not...

"... no computers ..."

Charles might disagree with that statement! 😛

David Ziffer (10/13/2010)

---

With regards to the "xxx": this is no different that putting things into .NET name spaces. Once again, the relational database does not give us any tools for...

You also have to bear in mind that it's not simply a choice between paying for an upgrade or paying to develop a workaround - it's a choice between paying...

Great article - I could have done with reading this last night!

One small suggestion - you can sometimes work around the 8921 Check Terminated message by specifying the WITH TABLOCK...