The testing I've seen and read about suggests that, by and large, uniqueidentifiers are poor choices for indexes, especially clustered indexes, because of their width. I've also seen testing that...

And that, of course, is the absolute strongest argument for using nothing but artificial keys. But, even so, there are business definitions that can allow for the use of natural...

Almost all the time, it's better to allow SQL Server to control the locking scheme in your queries. There are exceptions to this, but the exceptions should be exceptional.

It sounds...

Check this in the Books Online for details:

DBCC CHECKIDENT(TableName,RESEED,1)

Since all the work is being done on the server, how many different settings are likely to come out?

What they want to do, if I'm reading this correctly, is get...

4.

We had to track versions over time, so we created a version table, put a key for it in every other table and then did nothing but inserts into all...

OK. I got it to work... eh. I'm underwhelmed by this one. I get more out of Red Gate's SQL Prompt, easier.

One serious comment. If documentation is supplied, it really...

Well it sure doesn't work by default. I tried it in 2005 and 2008 and received nothing. I also note, that the answer, ALT-F1, is not listed in the documentation...

Take a look at the execution plan. Usually (and there are exceptions) you'll see that a query with a view and a query without a view, both of which reference...

What he's saying is, you can't refer to tables by variable names in regular TSQL statements. Instead you have to build a dynamic query as a string, inserting your parameter...

Take a look at the OUTPUT clause. You can use that to capture inserted data, including identity values, into a temporary table for use in later processing.

In order to use a foreign key constraint you have to have either a primary key or a unique index/constraint on the table to which you are referencing. Otherwise, you'd...

We ran into a similar situation once, but in an OLTP system. Long story, short, we only had to do this in a few places and the data load was...

Access the INFORMATION_SCHEMA views. There's one for tables, columns, routines, parameters...