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://qa.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...

Toreador (12/8/2009)

---

sknox (12/4/2009)

---

Steve Eckhart (12/4/2009)

---

select cast(1.67574 as decimal(38,10)) = 1.675400000 which has precision 6 and scale 10, right?

and

select cast(10000 as decimal(38,10)) = 10000.0000000000 which has precision 1 and scale 10,...

Scott Coleman (12/7/2009)

---

The LEN() function ignores trailing spaces, comparing the strings doesn't actually ignore trailing spaces but it pads the shorter string with spaces. The answer's the same either...