Tagged Questions
2
votes
2answers
51 views
Is it possible to insert multiple names in same cell?
I’ve a stored procedure that will get a person’s last name and insert it under Alias after she updated her last name on a form. But my boss wants to keep all previous last names whenever a person ...
0
votes
0answers
18 views
Trouble converting MySql Database to SQL Server [migrated]
I have an mysql database that contains 38 tables. I used "SQL Server Migration Assistant for Mysql" tool to convert this database to SQL server Database. I successfully converted 37 tables. Only one ...
2
votes
2answers
60 views
Database Design : Is it a good idea to combine two tables with the same columns and too many data?
I have two table with the same columns,one is use to save bank's amount and the other to save cashdesk,they both might have many data,so i'm concerned about data retrieving speed.I don't know it's ...
2
votes
3answers
62 views
Adding a database relation in order to decrease joins and increase performance
I am using SQL Server 2008. My question is regarding relational database design.
I got the following tables and relations:
Contract: I have a 1-M relation with Laborer. We expect like half
a million ...
2
votes
1answer
68 views
Slowly changing dimension - What is Pure type 6 implementation
I am trying to understand pure type 6 SCD implementation from WIKI which says mainly three points
Having a Type 2 surrogate key for each time slice can cause problems if the dimension is subject to ...
0
votes
2answers
57 views
SQL Creating multiple columns in View from one single table-column
I'm trying to create a View in SQL Server 2008 R2, where data is extracted from two tables with dual one-to-one relationships, and I want to create two columns in the view based values from a single ...
0
votes
2answers
104 views
Create a table with a dynamic number of columns in SQL Server
What is the best way to implement a table with a variable number of columns and different types?
(The number of columns is unknown)
We use a column of type XML. What do you think?
0
votes
2answers
32 views
How to design a table of worker roles
I need help with database designing.
So far I have three tables:
TblDepartments
--------------
DeptID (PK)
DeptName
TblSections
-----------
SectionID (PK)
DeptID (FK)
SectionName
TblWorkers
...
4
votes
1answer
56 views
Hiding initial value in Imported Database Model of Enterprise Architect
I am currently creating database model by doing reverse-engineering MS SQL Server 2008 into Sparx's Enterprise Architect version 10.
I have been able to import tables, and hide items that are not ...
0
votes
1answer
28 views
SQL DB Redesign for Retail POS - High volume transactions & Batch Processing
We are in the midst of getting out POS backend DB redesigned to support growth. Currently, our POS transactions are passed through to DB via a Web Service.
I understand that hardware scaling up is ...
2
votes
1answer
106 views
Which one is a better data design or object model?
Overview
I am designing a mechanism for generating dynamic controls in an ASP.NET MVC application that uses ADO.NET Entity Framework. However, my question has nothing to do with MVC and a little to ...
0
votes
0answers
45 views
Single DB vs Multiple DB [closed]
I've recently launched my first website, complete with Entity Framework 4.3/SQL 2008 Web Edition database.
I'm now looking to add further functionality to the site, however I've got limited knowledge ...
0
votes
4answers
81 views
t-sql single default value for multiple records
I have an MSSQL Server 2008 table that associates multiple photos to houses, as follows:
HouseID - with foreign key to House table
PhotoID - with foreign key to Photo table
It's all working great, ...
-1
votes
1answer
50 views
Representing Id's based on a prefix Microsoft SQL Server 2008 [closed]
I have a database with a table with companies ID's and prefixes. Currently when I query the DB for information I organize it by the company ID's, I want to also display the prefixes associated with ...
1
vote
1answer
39 views
Good architecture for app with variable list of attributes
We are breaking a large asp.net web forms app into chunks and one of the pieces will be rebuilt using asp.net mvc. There are 2 primary types of orders (lets say types A and B). Each order has ...
