Design Ideas and Questions

• Topics

  Started by

  Posts

  Last post

• Creating a data partitioned table, error on creating parttion function

  Hello, I've never created a partitioned table on SQL Server before, I'm on SQL Server 2016, and try…

  quinn.jay

  3 replies

  6 years, 4 months ago

  By: Sue_H

• Can't Remove File and Filegroup from Database for Partitioning a Table

  Hello, I had posted about my code used to create data partitioned tables, and got past the stumper.…

  quinn.jay

  3 replies

  6 years, 4 months ago

  By: quinn.jay

• table design help

  Hi All, Need some table design advice. I our environment, there is functionality call rules and a…

  vsamantha35

  4 replies

  6 years, 4 months ago

  By: vsamantha35

• Help with my table design

  Hi, I haven't got any proper DB design knowledge so please be patient and I'll do my best to explai…

  john_sidney

  3 replies

  6 years, 4 months ago

  By: Sue_H

• Table design considerations help

  Hi All, This is a general question regarding database design. I am not a db designer nor an archit…

  vsamantha35

  5 replies

  6 years, 4 months ago

  By: Jeff Moden

• Computed columns best practices.

  Hi all. I'm having a helluva time deciding whether or not to use a bunch of computed columns. I see…

  Kurt Wimberger

  9 replies

  6 years, 5 months ago

  By: Kurt Wimberger

• Best practices for storing a subset of IDs for SSIS

  Hi, all. I'm a relative newcomer to databases and ssis, but I'm learning quickly. This question is …

  zech 55624

  2 replies

  6 years, 6 months ago

  By: zech 55624

• How to Design Dimensional Model?

  Hi, Can any one shed some light on how to Design Schema / Dimensional Model with an existing non Di…

  Honeeysha

  6 replies

  6 years, 6 months ago

  By: RonKyle

• Multiple FK Tables or Single Table w/ Nullable/Empty Fields

  I am struggling to decide what the best direction would be to go for one portion of a database sche…

  blake 32570

  3 replies

  6 years, 6 months ago

  By: TomThomson

• Which version of SQL server is stable? Including service pack

  Which version of SQL server is stable? Including service pack?SQL server 2016 SP1/2014 SP 2/2012 SP4

  Vinayak15580

  1 replies

  6 years, 9 months ago

  By: NorthernSoul

• Application development, all features inside the database or seperate them

  I'm seeking your advice and / or experience about why and how for the following: Let says you're de…

  Megistal

  3 replies

  6 years, 10 months ago

  By: Sue_H

• Design contra CONSTRAINT

  Hi all! Using this oportunity to wich you a happy new year! Now my question!We are developing a C# …

  ca.zh

  8 replies

  6 years, 10 months ago

  By: Mike Good

• Schema Design - Product Packing Box

  Dear Experts, I would to know your valuable suggestions for requirement as mentioned below.Most of …

  kiran 4243

  3 replies

  6 years, 10 months ago

  By: ChrisM@Work

• Schema Design - Attributes Arrangement

  Dear Experts, Please refer to the below schema for your kind perusal. I would like to know whether …

  kiran 4243

  3 replies

  6 years, 10 months ago

  By: Eirikur Eiriksson

• footprinting a database

  Recently started working at a small company who's previous DB folk seem to have read the don'ts of …

  rtrim(ltrim(' '))

  4 replies

  6 years, 11 months ago

  By: Ed Wagner