If someone says that the registration date is more useful in their country and that this is an American-centric difficult question I will scream.

Suppose that your backups take a differing amount of time on any...

Probably so that it made scheduling log backups easier. If for some reason a full backup was taking longer than usual, a normal log backup could fail. This...

I got it right and skipped past E not because it could be SARGable, but because the index is keyed to StartDate and that IS SARGable, and I figured that...

I got it right simply because I once supported an app that had a myriad of situations with and without trailing spaces on a VARCHAR column and have seen that...

Well, this is weird, because in sys.databases DB ID is a straight up INT. So I wonder why smallint is the limit on databases then....

I would assume that system tables would be included in that....? My assumption on the limit is that SQL Server must use the smallint data type for the DB...

This is one of the best QOTDs I have ever seen here. I had to really think this through to get it right. I ALMOST just checked #1...

Hugo Kornelis (11/16/2011)

---

However, technically speaking they are not really correct. The message you get when running out of space in an index rebuild is different from the message I gave...

What's nice is that no one got out of control, angry, or vindictive. A good exchange with a positive outcome is a good thing.

SanDroid (11/16/2011)

---

Now if I could only determine why me, and others still see error 1105 when working with the table the way you mentioned. Could it be that all the...

If I understand your question, this should address it. Run the first two batches first, investigate the indexes, and then run the third batch. No errors.

Create table test1

(...

SanDroid, you have me totally confused. Hugo said that if you don't specify NONCLUSTERED on creation of a Primary Key on a table that has has no clustered index,...

Hugo Kornelis (11/16/2011)

---

vk-kirov (11/16/2011)

---

...but the question has a minor issue. When I created the QOD database with the DemoTable table and tried to rebuild the index, I got the following...

Yeah, in my case I am so used to the indexes being created as a part of making the foreign key that I failed to notice that they weren't part...