Topics
Started by
Posts
Last post
Hi there, I'm in the process of designing a simple data mart/warehouse against which user queries c…
3 replies
i need the list of disadvatages of denormalization
3 replies
I have done a lot of work with bulk insert recently. We are all familiar with BULK INSERT, SELECT …
2 replies
I am trying to get an undertstanding of Snowflake dimensions and how they could benefit the design …
1 replies
I have seen may sites refering use of surrogate key. The link http://www.dbmsmag.com/9805d05.html m…
7 replies
We have followed "best practices" by revoking access to base tables, and only allowing data access …
9 replies
We are relatively new to OLAP concepts within SQL Server and we are looking to revise our data ware…
1 replies
I have a couple of scenarios where forecast data is maintained at a higher level than the detailed …
1 replies
Hi, I came across this in Wikipedia, http://en.wikipedia.org/wiki/Database_normalization#Denormaliz…
8 replies
I'm not sure if WHERE clause should match exactly with index sequence to return the data quicker. F…
5 replies
hi there I need some advice regarding creating DIM tables. I have a relational table which has comp…
1 replies
I understand using primary key in tables for OLTP. But in case of DW I don't understand the use of …
1 replies
I work in a county education department. Each year we create/update a set of reports and procedure…
1 replies
Hello all I have created a prototype datawarehouse for my company using Analysis services 2005. The…
2 replies
Guys Hi, i have a question for you please! The management asks for a daily sailes report. This repo…
6 replies
Viewing 15 topics - 481 through 495 (of 539 total)
You must be logged in to create new topics.