Topics
Started by
Posts
Last post
Please could someone let me know upto how much we could go for normalisation, i have a Owner databa…
4 replies
Hello I have a SQL2000 Data Warehouse that is running on hardware that is close to failure. What I …
1 replies
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
Viewing 15 topics - 481 through 495 (of 541 total)
You must be logged in to create new topics.