Jeffrey - Interesting post. I've taken MS's "don't install a CU without a specific reason" seriously (even though I modify registries and list systems files, ha!)

And I've also had...

It probably varies by business. I bet we actually have more information than data - but I don't think that's common. (We're a large professional...

We all hear and accept that "we have all this data but don't have the information". (Actually, seems I'm not the only one here questioning that).

It's one of those...

1 more saying: detach, move, attach - or dump, load.

I'm talking about databases and engines, not the rest of the Ginzu Knives that come with SQL Server.

Doing the OS install...

Steve,

You're quite right about small lessons.

I was amazed the day a co-worker (one of the most db-savvy, but very set in his ways) decided that stored...

Steve -

Here's the difference: I'm on salary. And it's not a bad salary.

If I were more of a risk taker, I'd jump to consulting. ...

See what Jim Gray had to say about "object" databases, in the ACM/SIGMOD interview reprinted in the Tribute issue that came out a few weeks ago.

And he should know, being...

The usual answer applies: it depends!

The problem is that decisions on parallelism are made on the basis of the query, and not on the basis of the overall server workload....

Egad - where are my manners! I forget for a moment that redgate sponsors this excellent forum, and here I'm talking about SQL Server backup from Unix with Perl....

Glad to hear it (about the bigger tests). Of course, different setups of IO, CPU, concurrent work load etc are issue too, but you're putting a down a...

Nicely done article. However, we can't assume linear performance on larger databases - 100GB or 10 TB. (Is 100 GB still considered large? I remember considering...

I'll take us in a slightly different direction.

1. Based on the decription of the project (a casual collection of personal book reviews), why are you bothering with a database? ...

A great article for its purpose - well done.

A note, however, that software vendors should not assume that they will be permitted server admin access to a...

Jack Corbett (10/15/2007)

---

I would actually agree with Colin on this one. You need to know that, yes you can have a non-clustered primary key and, depending on what your...

Interesting - I just learned something. Bookmark lookup? Sometimes in SQL Server they come up with new names. My guess was it...