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

Are the servers the same? Do they have the same amount of memory and the same size and number of processors? Like Gail already said, what do the execution plans...

Good point on schemas. Although there, again, is a bunch of behavior that simply using it to group tables by function without also taking advantage of the security & execution...

One thing to consider as well is that sprocs are vendor specific and require rewrites if you move from your current database platform, while there may be less changes if...