A very timely article for you to post from my point of view. I need to perform a large data migration soon so this could come in handy in some...

Great article! It's good to see some ideas on how to implement the front end a FTS deployment. Understanding the benefits of the feature from a database perspective is easy...

Are there any plans to be able to specify a team repository for templates in SS 2008?

We had to implement a similar solution as outlined in the article which works...

Thanks Wayne. Lets hope that 2008 deals with this issue without the need for these sorts of workarounds.

No problem!

Another question though, we have had...

Finally, if the zero date is the start of 1900 and the dates can go up to the year 9999, why can they not go back as far using negative...

"datimeoffset" stores both date and time components and the time zone offset, ranging from 1st January 0001 to 31st December 9999, with accuracy of 100 ns, for example: "2007-10-14 19:35:09.3579284...

Jonathon, it is a little confusing as to whom you are speaking in that last paragraph since you mostly address the post by tymberwyld, although you mention "the article", which...

If there is a concern that the number of lookup tables will exponentially grow and you wont know where anything is....I guess that is a different topic.

And hence forth, you...

I think you misunderstood.

There are folders within the template explorer I am trying to remove, not the template explorer itself.

Folders that I remove from the template explorer keep reappearing...

Doesn't this overly complicate what should be a simple design.

If you want to store address_types then create a table called address_types and store them in there. If you need a...

I'd agree with post instructing everyone to hard-code the value into a variable at the top of your code although I would always do so by referencing a lookup table...

One of the strongest points of this website are your daily emails. The layouts have always been great and there are always plenty of articles covering a wide range of...

I prefer the 'ColumnAlias' = column_A approach because it very plain to see which column names are made up and which ones are actual columns that exist in the database.

Is...

The dinosaurs are dead so why can't this be killed with them