Perfect topic for the day. I had similar feelings as I was writing and scheduling my blog [/url]that went out today.

Returning an unexpected result is a query that fails. It may not generate an error, but the query still fails.

As I said in my previous post, the query as...

1.5 years later and it is strikingly accurate. I should print this and hang it all over the place.

Even better if it would snow outside now....

I like that.

That still won't cover all of the bases. ...

Can you show us the one that is failing? This query works fine for me.

Until then, I can speculate that there is rounding involved in the query that is...

GSquared (12/20/2011)

---

Dev (12/20/2011)

---

GSquared (12/20/2011)

---

Dev (12/20/2011)

---

Sorry for hiccup. I Google-d something today (after a long long time, using Bing now days) and didn’t find a single sponsored...

Some of the builtin procs do use multiple queries and also utilize cursors to generate the result.

In the case of spaceused, I prefer to use this query.

http://jasonbrimhall.info/2011/11/17/table-space-revised-again/

Brandie Tarvin (12/20/2011)

---

Dev (12/20/2011)

---

Sorry for hiccup. I Google-d something today (after a long long time, using Bing now days) and didn’t find a single sponsored links there. No...

Have a look at this connect item.

http://connect.microsoft.com/SQLServer/feedback/details/217685/msit-sap-build-3021-sql-error-17886-client-connection-errors-and-continuous-restarts

NO NO NO NO NO

Yeah - you still have to be careful there. Not sure what the resell laws on that software are. 😉

R.P.Rozema (12/20/2011)

---

:). Yes, that's how this question got to be: I did it wrong myself. And so far almost half of the people who tried, had it wrong too. To...

Seemed familiar from a tweet conversation involving you.:cool: