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...

You still can't buy it though. All they're offering is the "Readiness" disk and the July CTP.

Today? I seriously doubt it, but this is the first time I heard this rumor.

IDENTITY columns do not duplicate, even without a constraint, when operating normally. You can force duplicates in by using IDENTITY_INSERT or by doing a RESEED, but the normal behavior is...

When you say duplicated, do you mean in the data? I've never seen that in normal functions, it must be a bug or you're not using the IDENTITY setting and...

The newest version of Red Gate's SQL Prompt will do that for you and lots more. Also Red Gate's SQL Refactor has a way to clean up the layout of...

And just like your last post, take a look at the execution plans that will tell you a lot of what you need to know for making these sorts of...

Check the execution plan. WHERE clause order can affect some execution plans, but won't affect all. On a very simply query like this, it's unlikely to make a difference.

dale_keller (7/30/2008)

---

Thanks....I'll throw another question at you. I have a UDF which is called from a select statement which goes after several tables to get results. Based on...

gcopeland (7/30/2008)

---

Scott, you took the words right out of my mouth. I have always disagreed with the mindless use of sprocs in the design of systems, and I am...

I don't entirely understand the question...

You can insert into two tables:

INSERT INTO A

INSERT INTO B

But that's going to sequential, not simultaneous. In order to do them "at the same time"...

From the first link:

So, I guess the only way round this is to disable the constraints - an option if your system is suffering from blocking or excessive reads caused...