How distribute many columns in one table in SQL Server 2012 database
JAttanonRadar
I am thinking about problem in our database.
I have one table for our products. It has few columns that it's for all products common. But products belongs to a manufacture. And each manufacture need some columns for the specification of product. So I am thinking about distributions for our table..
I think that have it all in one table is waste for memory. Because for example I have 20k products for Apple and 30k for Asus, 40k for MSI.. so if I have it all in one table for columns for apple will be NULL for 70k records..
Another idea was that I have few tables for each manufacture and in products has some key that pointing to specific table with columns for Apple.. for example key can be apple1, apple2 and so on. But with this idea it was quite difficult to show all products with theirs specific columns.
So I want to ask if someone thinking about this problem in database.
I am using SQL Server 2012 for our database.
Thanks for any help to this problem.
Andrzej Reduta
You can use such structure... It's just example...
If You want to compare specifications, table with product data will be more complex...
이 기사는 인터넷에서 수집됩니다. 재 인쇄 할 때 출처를 알려주십시오.
침해가 발생한 경우 연락 주시기 바랍니다[email protected] 삭제
에서 수정
관련 기사
Related 관련 기사
- 1
How to create SQL Server 2012 database with C#?
- 2
How to search a column name in all tables in a database in SQL Server 2012?
- 3
Merge data into one column - sql server 2012
- 4
Database Schema - Create one large table or many?
- 5
Bulk insert into the SQL Server 2012 database - C#
- 6
SQL Server : stored procedure many-to-many table query
- 7
How to count row in SQL SERVER 2012 using sys.partitions
- 8
How to debug unattended installation of MS SQL Server 2012?
- 9
How to split one large database table into multiple database tables
- 10
SQL Server 2014 대 SQL Server 2012
- 11
SQL Server select * from table where columns in list
- 12
Split rows and columns in SQL server and insert into temporary table?
- 13
Restore SQL Server 2012 error
- 14
SQL Server 2012 제거
- 15
SQL Server 2012查询混乱
- 16
SQL Server 2012 쿼리
- 17
SQL Server 2012 Select 문
- 18
ERROR 1045: Transferring SQL database from one server to another
- 19
How to import huge blob into SQL Server database?
- 20
database schema one column entry references many rows from another table
- 21
Windows Server 2012, SQL Server 2012 및 .NET Framework 4.0
- 22
SQL server : Inserting/updating missing data from one table to another
- 23
How to distribute content to columns with border between them? (wordpress)
- 24
How to change the name of table in SQL Server that is a keyword
- 25
SQL Server 2012-동적 SQL
- 26
SQL Server 2012에 SQL 삽입
- 27
Query Optimisation - Collating result from one to many relationship table efficiently in SQL
- 28
Simple SQL Server Insert - Many Comma Delimited Values from Textbox to ONE Column
- 29
SQLite Database for a RecipeApp (one-to-many relationships)
몇 마디 만하겠습니다