Considering nobody has responded, I'm wondering if the question was phrased poorly, placed in the wrong forum, or simply not interesting. But for what it's worth, I did find a...

Here is my take:

SET NOCOUNT ON

--

-- Build calendar table

--

IF OBJECT_ID('tempdb..#Calendar') IS NOT NULL

DROP TABLE #Calendar

--

CREATE TABLE #Calendar (

CalendarDate datetime not null primary key,

...

If you want a great learning resource for Profiler, I would recommend Brad McGehee's free e-book "Mastering SQL Server Profiler."

http://www.red-gate.com/products/SQL_Response/offers/mastering_sql_profiler_ebook.htm

It looks like the Type 3 approach has won out. But on the flipside, if management changes their mind for new features in the future, I have a much better...

Here is my understanding of the Slowly Changing Dimension article as applied to the original example. There are multiple methodologies used to track historical data and each one is specified...

First off, thanks for the replies. Your answers made me feel confident about the approach and helped me sell the concept to the team leads. I have begun working on...

I appreciate the explanations. I came across some SELECT statements written by a co-worker with keyword columns in at least five different places and I realized that while I knew...

lol...thank you.

Have you considered having a conversation about this with your hiring manager? I think you have a valid concern and work experience is very important in this business.

It would...

I knew about MSDN but not Developer's edition...that sounds like the best idea so far. Thanks for the advice.

I find this article to be exemplary of what I believe to be an inexplicable hostility in many technical interviewers. Over the past three months, I've been on multiple interviews...