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

You don't need to create a diagram, but you can if you want to visualize what was created on the database. If you want to use the GUI to check...

I thought it was fairly expected and common to put indexes on foreign keys (depending on needs of the queries used, etc., of course). I've never seen any documentation from...

There's really not a difference between a query and a procedure. A procedure is just a query stored in the database. Queries can be parameterized just like queries. In fact,...