I apologize for not being clearer. I need to count the number of signups that occurred on the last hour of that signup.

For example if we look at this data,...

Thanks, but that is not what I am looking for.

The end result should be CREATE_DATE, CUSTOMERID, NUMBEROFSIGNUPS

And each NUMBEROFSIGNUPS will give you the # of signups that were created on...

Thanks, I do understand that the monitoring only gives you a big picture and you need to go and dig.

Ideally we wont get a tool that gives me what I...

PhiI am trying the method on the link, but I am not sure how to bring the where without scanning the whole table every time

UPDATE HubHistoryData WITH...

thanks

thanks!!!

what...

what...

i did not choose the type of table it is, I don't even know what the table is for. I was just asked to create a hub

This is a special table, that the column are the composition of that primary hash key. That is why are all there.

I could check about checking between nvarchar and varchar.

Thanks

Thanks for the reply. This is the table I need to make - we follow the datavault.

I am able to build the table but I get a warning:

Warning! The maximum...

They are in the same data center.

And not only that but they are in the same server, both virtual servers

thanks, but that is not my issue.

my issue is that when the server tried to bring the data is slow but when it get pushed from outside the network is...

Thanks to you both, the number was not consistent and that is why I was not sure how to split it.

I need to get stronger on using cross apply.

thanks again....

There is a book my boss uses called building a scalable datawarehouse with data vault 2.

and it gives specifics instructions on how to use the code. that is from where...