Design Ideas and Questions

• Topics

  Started by

  Posts

  Last post

• Use of HierarchyID objects

  Hi I've hit a bit of a mental block on my database designessentially it's a tree view of a com…

  MVDBA (Mike Vessey)

  1 replies

  1 year, 3 months ago

  By: andycadley

• Foreign Keys

  Is there any merit in having a foreign key which references a non-clustered index in another table,…

  HappyGeek

  19 replies

  1 year, 4 months ago

  By: Grant Fritchey

• T-Script Error on resetting Counter

  Hello, When I run this T-SQL script that begins a dynamic way to create table partitions, I’m fin…

  quinn.jay

  9 replies

  1 year, 4 months ago

  By: quinn.jay

• 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

  1 year, 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

  1 year, 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

  1 year, 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

  1 year, 5 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

  1 year, 5 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

  1 year, 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

  1 year, 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

  1 year, 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

  1 year, 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

  1 year, 10 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

  1 year, 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

  1 year, 10 months ago

  By: Mike Good