Matt Marston (9/30/2009)

---

A B-tree could only be confused with a binary tree if it is binary with each node having at most 2 children. Wikipedia states this clearly, "a binary...

Warren Gilbert (9/30/2009)

---

There are several references to the fact that the meaning of the 'B' in B-Tree is undefined, but since this site is 'Microsoft' SQL Server related, the following...

I don't understand how it could return both the current and the last timestamp used. According to MSDN, @@DBTS returns the last-used timestamp value of the current database. A...

This one caught me too. In 2000, it was a table but they switched it to a view in 2005 for backwards compatibility. The question specifically asks about...

This one tricked me. I didn't know all three versions used different exe files so when I saw the one I recognized, I selected it and got it wrong....

Although I got the question right (I did not notice the extra comma), I agree this is a bad question. When you get the error message, no records get...

Suppose it depends on which query tool you use. If you use the one built into Microsoft SQL Server Management Studio, it does display in scientific notation.

SQLDBX displays as...

SQL 2005 actually displays the answer as 1234567936. I tested this to make sure. The scientific notation might only be displayed depending on your local configuration options.

Here's the ultimate method.

I tried to create an example using the identity column but it required additional queries which wasn't so efficient. Still, it was more efficient than creating...

If I'm not mistaken, since this uses the identity column, it might not always produce the same number of columns. For example, if you deleted a couple rows in...