I've found the posts about open source interesting and good reading. On the whole, I like the open source business model; however, in this case, my client has a compelling...

I don't know of a document that spells this out but the bottom line is this: the only way to keep IT out is to set up a separate instance...

After doing some performance testing against a sample database of a million, records I found indexed views are as fast as pre-aggregating the data. So, my proposal to my client...

Do you need to maintain the relationships between the levels of aggregation? I mean, will the total sales of city1, city2 ... cityN in state1 add up to what is...

I'll consider it. I see it useable with either design approach.

A lot of what you use depends on what you're doing. "Right tool for the right job" type of thing. I've found that if you want to grow an Access...

You can also skip the table creation steps and select directly into the table:

Select <myfields> Into ##NewTable From <myTable> etc.

This does create a temporary table to file. It's structure is...