Toreador (11/4/2010)

---

I knew what the answer was, and thought that "The maximum Tax Rates across all State/Province IDs" described it well. I supopose I should have read more closely and...

Now wouldn't it be fun if a unification capability were added to SQL so that you in an insert statement could specify the values of some computed columns and leave...

Avoid this...

writual

Jeff Moden (11/2/2010)

---

Grant Fritchey (11/2/2010)

---

For those who don't know, several of our locals are up for an award at SQLServerPedia for blog posts done over the last year. Gail is...

Actually you could do it in SQL2000. Although the EM GUI doesn't allow a...

Alvin Ramard (11/2/2010)

---

The problem is that it may go an hour without running.

Let's take Wayne's example and shift it forward by 1 minute.

At 1:46 AM, the job runs and when...

A bit early for that?

Blimey! That dbo.easter function could form the basis of an article on "How to write...

A fun question, that suggests less than fortunate consequences of SQL's bizarre implicit type conversion and type precedence rules. In SQL (unlike almost every other programming language) it is...

Good question, but as some have already noted the explanation is a bit lacking.

Also, the question was made too easy by the absence of the All 2s option as an...

Stefan Krzywicki (11/1/2010)

---

jcrawf02 (11/1/2010)

---

Tom.Thomson (11/1/2010)

---

There could be a similar interesting question about the other daylight saving time shift shift (in 6 months time). Will jobs scheduled to start between...

There could be a similar interesting question about the other daylight saving time shift shift (in 6 months time). Will jobs scheduled to start between 0200 and 0300 fail...

Not only is the explanation wrong, as several people have pointed out, it is also uses somewhat outdated terminology and is maybe confused about which version of SQL it refers...

GilaMonster (10/28/2010)

---

Normalise fully. 4th normal form is probably a safe place to stop. Denormalise as necessary and with good reasons. Not bothering to normalise past 1st is not denormalisation, it's...