Design Ideas and Questions

• Topics

  Started by

  Posts

  Last post

• Indexes with datatype char

  Hi guys! I have an question, in my environment I have one table that the most of columns is char da…

  Oliveira, Douglas

  5 replies

  13 years ago

  By: Steve Jones - SSC Editor

• Confused about how to design a new process (third week into new role)

  Good afternoon, I'm not sure if I'm posting this in the right section but I could really do with so…

  Abu Dina

  11 replies

  13 years, 1 month ago

  By: GSquared

• Pros and Cons Between Two Design Approaches for New Database to Support Workflow App with Conditional Validation

  Thread deleted.

  tnk

  2 replies

  13 years, 1 month ago

  By: tnk

• Pros and Cons - Table with loads of uniqe columns VS Row based keys with row data type

  Hi, Which one is a better design strategy with respect to flexibility, performance and maintainabil…

  iBar

  10 replies

  13 years, 1 month ago

  By: MalD

• Best way to deal with millions of very short rows?

  I'm fairly confident in my SQL design skills, but I thought I had better just throw my thoughts "ou…

  gregrobson

  6 replies

  13 years, 1 month ago

  By: gregrobson

• Column naming convention

  Hi All, Looking for opinions on something. I've never seen this before, and I'm of mixed opinion o…

  Tom Bakerman

  8 replies

  13 years, 1 month ago

  By: Devendrakumar

• Surrogate Key vs Natural Key DImension Tables Dimensional Model

  Could someone please help me explain to a nontechnical person why it is bad practice to use the Nat…

  Welsh Corgi

  4 replies

  13 years, 1 month ago

  By: Lokesh Vij

• Urgent Normalisation help!!!

  Hi Guys i relly need help i need to do normalisation but i cannot get my head wraped around it can…

  Aty01

  59 replies

  13 years, 1 month ago

  By: Lokesh Vij

• Nasty, nasty, nasty....

  I've just been handed a database to look at which will be going live in a few weeks and it's horrib…

  Stueyd

  11 replies

  13 years, 2 months ago

  By: Grant Fritchey

• some advice for TMS Design

  Hi I have design database schema forTask management System but I need some advice to finish it and…

  a-elnajjar

  1 replies

  13 years, 3 months ago

  By: robert.gerald.taylor

• Need help with table design

  Hi Guys, I have a main table called File: /****** Object: Table [dbo].[File] Script Date: 05/02…

  niteshrajgopal

  1 replies

  13 years, 3 months ago

  By: okokon.joseph

• Tally table question

  I have been happily using Tally tables to good effect since I first read about them here (Thanks!),…

  lnoland

  2 replies

  13 years, 4 months ago

  By: lnoland

• Moved from Main - CI Sub-Forum?

  -- Apologies for not posting here first time 🙂 .... Hi, I've been working on putting together a CI …

  Craig@Work

  1 replies

  13 years, 4 months ago

  By: David Atkinson

• Advice?/Suggestions?/Recommendations?: Configuration & Implementation

  I'm attempting to develop a scale out plan for existing SQL Servers. Current configuration is irrel…

  Felicia Coons

  3 replies

  13 years, 4 months ago

  By: PaulB-TheOneAndOnly

• Designing a database for a tennis league

  hi all, how to Designing a database for a tennis league . how to design and Architecture and table…

  Database admin(DBA)

  8 replies

  13 years, 5 months ago

  By: Gail Shaw