Now that I'm thinking about it (and I'm also asking around) unless the database is only a single filegroup, it's unlikely that it would show up as an actual locked...

Ooh. I hadn't thought of that.

It wouldn't show up as a database lock though, would it?

There you go...

I was at a meeting of our town Board of Health this week (they're trying to pass regulations on Outdoor Wood Furnaces). One...

Hrmmm...

Unless this is the only table in the database, I'd be really shocked to see a database lock based solely on inserts to a single table. I'm guessing there's a...

So I guess the guideline should be don't publish anything that can be linked to you that you wouldn't want published in the newspaper on the frontpage with your name...

If TypeID and LangCode are the PK's that are meant to be used to link to the Object table (parent to child), then the Object table needs to also have...

Last comment. If you google my name the first result is The Jack Corbett Guide to Topless Clubs, which is NOT me. You get me as the 5th...

Once you pass a certain number of rows, the engine has to lock the table to be effecient. There's no getting around that fact. So, instead, you have to look...

It's just a chapter out of a larger book. The information is likely to be good, but it could be pretty light.

I'm honestly mixed on this one. On the one hand, it's none of HR's or the company's business what I do in my off time. On the other hand, participating...

Hey Jack,

You know, I do forget about that threading thing. Holdover from the days of 2000. I will say, it still doesn't work quite like having multiple connections from multiple...

It's an ancient book. But hey, relational databases are relational databases. It's not til you get to all the funky queries and ETL and all that fun stuff that 2000/2005/2008...

Tuning Advisor stinks.

I've used Profiler to capture production and then play it back. It's actually pretty easy. The real key is that you absolutely have to recover to a precise...

Fleming & von Halle's "Handbook of Relational Database Design" is one of the best introductory books that I'm aware of.

As several people have already posted, that's just too vague a question to give you a good answer. If you're really stuck on how to get started, here's a basic...