Design Ideas and Questions

• Topics

  Started by

  Posts

  Last post

• Separate databases for configuration, stored procedures, and data

  I am working on a new data warehouse project with complex validation and transformation requirement…

  Walter Levy

  7 replies

  10 years, 11 months ago

  By: Grant Fritchey

• Best Practice for Storing Spatial Data in Multiple Projections?

  From what I've been able to determine MS SQL can't do reprojections is that correct? Assuming it is…

  Randy SK

  3 replies

  10 years, 12 months ago

  By: Randy SK

• How do I fix my tables to go back and retreive history information?

  I have two tables, Schools and SchoolHistory. This is basically in a simple design on what is goin…

  cbernardes

  12 replies

  11 years ago

  By: Steve Jones - SSC Editor

• Warehouse data design for time-sheet management data.

  Please suggest : I have to design a warehouse(DW) database for time-sheet management. Here is the O…

  vineet_dubey1975

  1 replies

  11 years ago

  By: vineet_dubey1975

• Table Design

  Hi, I'm a newbie in database design, hope you guys can help me with the following scenario. Let's s…

  azmiman

  7 replies

  11 years, 1 month ago

  By: sqlvogel

• Research on possibility of RDBMS to have performance benchmarks like no-sql Databases

  There is a blog series i have created on wordpress. http://ratneshparihar.wordpress.com/2014/07/28/…

  ratneshsinghparihar-1130833

  12 replies

  11 years, 1 month ago

  By: TomThomson

• Cocktail Recipe Database Schema - Tables Question - Normalization

  I'm fairly new to database design. I have done a few in the past, however, I am trying to normaliz…

  MikeyLikesIt

  11 replies

  11 years, 1 month ago

  By: Chrissy321

• need help to design wills database

  hi there i am new here and especially to design database aim currently in school i need help to des…

  paul pius alibin

  3 replies

  11 years, 1 month ago

  By: Grant Fritchey

• Procedures and functions with cross-database dependencies

  Long story short - our company's primary operational database is poorly designed and has been poorl…

  joshturnbull90

  3 replies

  11 years, 2 months ago

  By: Jeff Moden

• Architecture/Design for maintaining multiple version of an application database

  We have a Silverlight based application which currently supports only one production version. Idea …

  saikat.pan

  1 replies

  11 years, 3 months ago

  By: free_mascot

• Database Design Best Practice Question

  I am building out a database (please see sample attachment) and I am second guessing myself on my d…

  SQL Shibe

  2 replies

  11 years, 3 months ago

  By: SQL Shibe

• best practices for storing ssn?

  A company I work with stores all HR data for all past and present employees in a table that has SSN…

  Maxer

  7 replies

  11 years, 3 months ago

  By: Eric M Russell

• Audit approach for performance tunning

  we do have requirement of tracking insert,update and delete action of tables with tracking userid. …

  Megha P

  3 replies

  11 years, 4 months ago

  By: azmiman

• How i make ERD Diagram for payroll salary for employees

  Hi guys i want to make database for payroll only but i don't know how to make structure for this su…

  ahmed_elbarbary.2010

  4 replies

  11 years, 4 months ago

  By: Michael Valentine Jones

• HIPAA Compliant Architecture

  Hi, I am developing a Medical Billing Software and should be HIPAA complaint. My current architectu…

  rinshadka_2445

  1 replies

  11 years, 4 months ago

  By: sql Sarah