Design Ideas and Questions

• Topics

  Started by

  Posts

  Last post

• How to make design for booking hotel and program ?

  I need  to design database for booking  tours  for tourism company Tourist  boo…

  ahmed_elbarbary.2010

  18 replies

  8 years, 2 months ago

  By: prvmine

• Need some pointers in the right direction Excel to SQL

  Hello guys, I'm new here and new to the forums in general. I see that you can find an answer to yo…

  Whiteshadow

  8 replies

  8 years, 2 months ago

  By: Jeff Moden

• Table Design for Tracking Changes To A Record

  For the sake of this example assume we have an Employee table:First NameMiddle NameLast NameSa…

  thelenj

  1 replies

  8 years, 2 months ago

  By: Steve Jones - SSC Editor

• Clustered Instance in danger of replacement

  Dear Colleagues, How to demostrate, that one solution based on vm high availability is not the only…

  Lou

  2 replies

  8 years, 3 months ago

  By: Steve Jones - SSC Editor

• DWH Transactional/Incremental Extracts

  Hi, My DWH ETL has a Transactional/Incremental Extraction logic, where all new records from OLTP so…

  etl2016

  1 replies

  8 years, 4 months ago

  By: xsevensinzx

• (Newbie) SQL Table Design / Relationships

  First of all, I'm completely new to SQL, literally the first time I've ever tried to create a datab…

  Mycaelis

  4 replies

  8 years, 4 months ago

  By: Chris Harshman

• Schema Design

  Hello,Good Afternoon.I would like to known whether below DDL suites best.Explanation: After the job…

  kiran 4243

  1 replies

  8 years, 4 months ago

  By: Chris Harshman

• Database Server Topology Diagrams

  Morning Guys, I find my self needing to create diagrams in this style: https://docs.microsoft.com/e…

  alex.sqldba

  1 replies

  8 years, 4 months ago

  By: Grant Fritchey

• [Generic] Person ETL

  Environment : Many various disparate systems that contain unique person information. Task: Merge th…

  Dougieson

  2 replies

  8 years, 5 months ago

  By: Dougieson

• MS SQL Licensing

  If I have a developer reaching over from a SQLDev instance using a linked server into production is…

  lkennedy76

  9 replies

  8 years, 5 months ago

  By: frederico_fonseca

• Composite clustering key

  We have a table that stores ~3 billion rows with the following columns: [ID], [Year], [CustomerID],…

  Simon E Doubt

  3 replies

  8 years, 6 months ago

  By: Grant Fritchey

• Many to Many Relationship Design Query

  Hi, I am looking to design tables which contain tag(s) and their relationship with tasks (parent/ch…

  kevin.obrien 66193

  14 replies

  8 years, 6 months ago

  By: kevin.obrien 66193

• Normalized Schema Design

  Hi, I am working on a table design, which will store records of completed daily tasks. The table co…

  kevin.obrien 66193

  5 replies

  8 years, 6 months ago

  By: Grant Fritchey

• Just an observation: It seems odd that foreign keys cannot be references to unconstrained superkeys...*

  "Academic" description first, then a specific example. Given two tables, A and B, where... * k is d…

  Don Halloran

  5 replies

  8 years, 7 months ago

  By: Don Halloran

• Unique Indexing (case sensitive) ???

  I have a table with a column Password with NVarchar data type and want to store a unique value…

  Crown Clit

  3 replies

  8 years, 8 months ago

  By: Crown Clit