Yes, except that my question is

I will create a model of this...

SQLX, I thought that adding start/end date columns to hierarchy table was essentially the implementation of slowly changing dimension.

Hi Jeff,

Thanks for your time.

Answer: Hierarchichal IDs and Hierarchical Paths. Today, the idea of using hierarchyID was tossed, because it was advised one can't join to the hierarchyID...

K, thanks for the leads guys. Anyone want to add, feel free to do so. Appreciate all the input.

Helen

LutzM, thanks for the queries. Very nice learning experience.

Please elaborate, if you can, when to push back to front end. I have found it difficult to know when...

Sorry if I am way off base, but from my understanding, the Pivot operator is for aggregating information at the cross section of a row and column. Since dates...

Thank you. I learned a lot.

Looking, thank you!

If user names are in several of the system tables and DMVs, are you saying that they are not joinable to the index usage system table? Is there any...

So user names are not logged in any system tables, right?

And profiler would have to be run as long as necessary (month?....I know, depends) to get a good...

Thank you! I appreciate it very much.

I hate to pump up the urgency, but it is rather urgent.

Could someone tell me what is best way to find out: "How frequently and by whom a given database...

Lowell, or Gila, or someone!, would you mind also telling me which system table I can join to the sys.dm_db_index_usage_stats table to get names of users or userids that are...

Like this? (All the same queries, but modified with Null. This leaves Groucho out altogether).

create table staff(employee int primary key, employee_name varchar(10),

supervisor int null references staff (employee))

insert staff

values...

levity.....I tried.:laugh: He's given me a hard time before

Thank you Jeff!!!

I cannot, for the life of me, figure out why Ken wanted to create six copies of the same...