What do the execution plans look like? Maybe it's not using the uniqueidentifier at all?

OK.

WHILE (@StartDate < @StopDate)

BEGIN

SET @StartDate = DATEADD(month,1,@StartDate)

SET @EndDate = DATEADD(day,-1,DATEADD(month,1,@StartDate))

...

Yes, it is possible for the most part to build the data structure, tables, primary keys, foreign keys, and clustered indexes without having an application. Writing all the views and...

The problem is, even if you order the SELECT statement when doing the inserts, when you next SELECT from the table, you're not guaranteed the order it comes back in....

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