I'm trying to implement a recency measure for my individual customers,
telling me how many days have gone by since the last purchase of a customer.
I would like it to go something like this:
with member time.week.last_purchase_date as

Please pardon my ignorance here, but I'm a newbie with MS SQL Server.
I have a database that contains a table with 33.6 million records.  When I
built the table I used Nvarchar in several of the fields.  Now I'm thinking
that because the db size is 7.5 gb, that I could reduce that ...

I have a historical table that is over 100 million records in size.
Processing this table in AS takes an extremly long time (about 2 hours). Is
there any way to speed this up in AS?