Nice Question.Thanks Steve

Thanks Steve.

Just extended your query to identify current years thanksgiving day:

declare @date datetime

set @date=dateadd(yy,0,getdate())

SELECT DATEADD( DAY, 5-datepart(dw,DATEADD( WEEK, -1, DATEADD( MONTH, 11, DATEADD(yy, datediff(yy, 0, @date), 0)))), DATEADD( WEEK,...

Thanks Steve...

Just to add one point here:

Windows functions can be used directly in SELECT and ORDER BY Clauses only..

Good question...

Back to basics

Good Question...

That's why I prefer using count(1)

Nice Question!

or something like:

I see Other place where Microsoft is referring tabular database as cube.

in SSDT,right click your tabular project>Properties>Under Deployment server

I see "model" as cube name..

Thanks a lot Koen

Koen,I second that tabular model database is not a cube..

But I am seeing some Microsoft guys using word "tabular cube"

http://blogs.msdn.com/b/andreasderuiter/archive/2012/12/10/should-you-use-a-data-warehouse-with-a-tabular-cube.aspx?CommentPosted=true#commentmessage

or try creating triggers

is your table compressed?

Good Question ,,Thanks Steve

Also try attunity connector for oracle source.

In SQL server 2014,Microsoft seems to be mainly banking on Hekaton (In-memory) feature + Hadoop...