GilaMonster (12/9/2011)

---

Great if you're in the USA....

I don't bother with satellite TV. Too many useless channels and to get the ones I'd be interested...

Koen Verbeeck (12/9/2011)

---

I recently moved to a new house and I took the opportunity to get me and my family digital television (it's fairly "new" in Belgium).

So now I have...

Revenant (12/8/2011)

---

So here is the result, after 5:00:13 clean run on a Datacenter server:

Msg 1835, Level 16, State 1, Line 1

Unable to create/attach any new database because the number of...

Drat, I missed out 6 casts ("0" changed to "cast(cast 0 as datetime) as date)" in three places! :blush: I...

Daniel Bowlin (12/8/2011)

---

Cadavre (12/8/2011)

---

Just to over-complicate matters . . . 😀

SELECT CASE WHEN GETDATE() > DATEADD(d, 24, DATEADD(m, 11, DATEADD(yy, DATEDIFF(yy, 0, GETDATE()), 0)))

...

Nice easy question.

Richard Warr (12/8/2011)

---

A better question would be "What is the maximum number of databases a developer can handle?". I've got 8 open at the moment and...

Tom Brown (12/8/2011)

---

I think that volcanic air is getting to you Tom, This question is way over most of our heads - a really hard question. No amount...

Good question. The date format (mm-dd-yyyy) is irritating, but a fact of life, but obvious since a date in August isn't going to be week (whether WW or ISOWK)...

Steve Jones - SSC Editor (12/7/2011)

---

Jeff Moden (12/7/2011)

---

Revenant (12/6/2011)

---

Jeff Moden (12/6/2011)

---

To be honest, I didn't enter... didn't even try to answer a single question. They wanted a "tweet" from...

Evil Kraig F (12/6/2011)

---

Agreed, it's like opening Pandora's Box. ...

A good question - the sort of thing I would like to see more of because it's about understanding the system and its language rather than about remembering the reference...

Hugo Kornelis (12/6/2011)

---

I stiill stand by what I intended to write - that the only way to rewrite the query to a form that doesn't use nested joins involves reordering...

Ninja's_RGR'us (12/5/2011)

---

L' Eomot Inversé (12/5/2011)

---

That's startling. I don't have a...

That's startling. I don't have a modern (windows 7 or...

Michael Valentine Jones (12/2/2011)

---

This is probably the fastest and shortest method for finding the last day of the month, given the year and month as integers, since it uses only...