john.arnott (11/8/2010)

---

Hmmm. When I run this code to build the table, "Select 1 from #test" returns two rows, each with a "1". It's an implied join, isn't it?

Create...

Allthough not explicitly documented, the SQL Server data type supports the Gregorian calendar. The SET LANGUAGE affects...

And *that* is because of the change from...

Simple question, but with a complicated answer. And I'll start with a disclaimer - I...

Steve Eckhart (11/5/2010)

---

I also didn't want to just run the code to get the question, so I converted July 1, 2010 and January 1, 2010 to integers in Excel. Excel...

Probably because of February 29, 1900.

There is no such date. The full rule for leap years is not "evey four years",...

Terrible question. The only correct answer is "it depends", and that answer was missing.

If the default language of your server happens to be, for example, British English, you'll get 1...

sql.monkey (11/4/2010)

---

I have a table with an unindexed date column in a table of billions of rows

I collect the lowest and highest primary keys between those dates into variables

I...

tilew-948340 (11/4/2010)

---

My engish beeing what it is, I did also not get the differance between the first two answers, but that's ok. I learned something new and it is the...

David Ziffer (11/4/2010)

---

If you look at the ExampleCRM tables that have foreign keys that are defined for business purposes (not just the status-field foreign key) you will see the function...

(Not targeting you specifically, but everyone who posted and/or will post similar comments)

The question is good indeed - but please don't learn too...

It does. The code window has a scroll bar at the bottom; you'll find the column sstr.StateProvinceID...

Hi David,

I'm surprised to see so little comments yet. But who knows, maybe I'm not the only one with a reading backlog.

In the beginning of your article, you write that...

Hi Terry,

Thanks for the article.

It's definitely an interesting approach - but I miss an explanation. WHY does the second version run faster than the first? I would have expected the...

Jeff Moden (10/31/2010)

---

David Ziffer (10/30/2010)

---

I certainly would load rows into a single table as a group, but even those insertions must be done through individual calls to the RAP insertion...