Design Ideas and Questions

• Topics

  Started by

  Posts

  Last post

• Conceptual design and When to define schemas

  we are in the conceptual phase of our project.  UI design just finished and front and backend devel…

  Jason Wilks

  1 replies

  3 years, 4 months ago

  By: Grant Fritchey

• Create Index

  hello , i want creat indexs in my base on prod , can i do it when users are connected ans the base …

  jihene

  3 replies

  3 years, 4 months ago

  By: Jeff Moden

• ERD for Credit Card and Cash Payment Types

  I have the following tables: Customer, Customer Credit Card, Credit Card Order But a customer can a…

  Jacob Pressures

  7 replies

  3 years, 5 months ago

  By: Jessica.Wade

• Help with star Schema

  Hello I am just starting to learn about database designing, so as a start I am trying to create a f…

  cin

  6 replies

  3 years, 6 months ago

  By: donald.parish

• Users and users subtype entities

  Hello, I system requirements I have are as follows:  In my app,as far as person entities, let's say…

  Jason Wilks

  2 replies

  3 years, 8 months ago

  By: ratbak

• Metadata-Data-Ratio in a table

  Hi all, My understanding about the structure of data within SQL Server is that table data and non-c…

  sean redmond

  10 replies

  3 years, 9 months ago

  By: Steve Jones - SSC Editor

• Data Validation - matching Own Data with Externally Sourced / Spidered

  I have a table in my APP (the "APP" Table), it could be something like a VENDOR table with, let's s…

  Kristen-173977

  1 replies

  3 years, 9 months ago

  By: Kristen-173977

• Vendors Database

  Dear all, We are looking for web based system through which we can administer a large number of ven…

  Rose

  1 replies

  4 years ago

  By: Grant Fritchey

• Use a VIEW for all SELECTs on every TABLE for futureproofing?

  What are the downsides of using a VIEW instead of the table direct? I'm thinking of a VIEW which is…

  Kristen-173977

  12 replies

  4 years, 3 months ago

  By: Jeffrey Williams

• SQL newbie, question about primary key.

  Hello, SQL newbie here. I've got a question about the proper use of primary keys, hoping someone ca…

  SerolfDivad

  7 replies

  4 years, 4 months ago

  By: SerolfDivad

• Columnstore Index and Nonclustered Index on Table

  We have a table definition below with a columnstore index and nonclustered row indices. The data in…

  sadie

  5 replies

  4 years, 10 months ago

  By: Grant Fritchey

• db table design

  Hi guys and gals. forgive me if this questions is in the wrong place, new to the forum and sql deve…

  cole-p

  2 replies

  5 years, 3 months ago

  By: MVDBA (Mike Vessey)

• Star Schema draft

  I'm trying to figure out if this star schema works for counting the quantity of products in the war…

  TestKing2017

  9 replies

  5 years, 5 months ago

  By: RonKyle

• Buy and store desing

  Hi I need to design to register the purchase and enter the products into the warehouse, make transf…

  minimainor_austin

  1 replies

  5 years, 5 months ago

  By: minimainor_austin

• Replication- Design Help

  Hi everyone, I'm new to the forum and am helping to get a little education on something. I'm helpin…

  RS-HOF

  1 replies

  5 years, 7 months ago

  By: RS-HOF