This article leaves me with more questions than answers.

First off, there are no indexes on the table in the example. How would adding indexes and inserting non-sequential data affect the...

I'm honestly surprised at the number of people here who were not aware of the approximate nature of IEEE floating-point numbers. That information was in every programming class I took...

Michael Poppers (1/6/2010)

---

john.curran.z3g (1/6/2010)

---

Ideally this question would have included the Categories table with the INSERT to remove the dependency on Northwind. This would also remove any doubt as to the...

Hugo Kornelis (12/24/2009)

---

But...

jrhutch (12/22/2009)

---

Can't help but notice that we have 3 options: true, false and error. If we get an error the answer is still going to true or false. ...

vk-kirov (12/17/2009)To those people who answered '1,3,4': is the condition 'all active tasks have stopped referencing them' sufficient for dropping the table? The answer is 'No, it is not'. If...

1,3,4

Even the answer explanation states that if the session that created it ends, but an active task is still referencing the table, it isn't dropped. So #2 is NOT correct.

Because we're not actually running the function on the same variable. In the first column, we're doing...

In this article I’m walking you through how to setup data file free space monitoring using SQL Server 2008 Policy-Based Management feature. You may think “Hey dude this is not...

I dream in binary, so when I see 32768 I automatically think overflow*. 😛

*At least in regards to Microsoft stuff. They seem to dislike unsigned integers, for some reason.

Well, on page 2, I have a post which illustrates one potential answer, based primarily on the equations but rewriting them as a procedure (http://www.sqlservercentral.com/Forums/FindPost828945.aspx), and shortly thereafter nadabadan does...

To each his own. I prefer using SQL...

chriscoates (12/10/2009)

---

Thanks sknox for some good explanations here. To check I've got this straight ...

The internal casts give us 10 decimal places.

That effectively boils down to:

SELECT ( 1.6757400000 /...

RBarryYoung (12/9/2009)

---

Steve: (RE: SSC new site features/wishlist)

This is a perfect example of a thread or post that I would like to be able to tag or remember...

RBarryYoung (12/9/2009)

---

As for the last part, you appaerntly overlooked applying the MAX(..) function in your calculations:

According to the table from the above link, the result precision is: p1 - s1...