Design Ideas and Questions

• Topics

  Started by

  Posts

  Last post

• SQL clustering vs. virtualization

  Hello, I have a problem choosing between clustering and virtualization solutions. We have an SQL se…

  parissa_bakhshi

  7 replies

  14 years, 10 months ago

  By: PaulB-TheOneAndOnly

• Does clustered table have IAM page?

  I am trying to better understand SQL Server internals - indexing, data structures, memory/storage a…

  vgv8

  17 replies

  14 years, 10 months ago

  By: Gail Shaw

• Why/how/when Full Clustered Index Scan is preferred over Full Table Scan

  Context of question(s): SQL Server, the clustered table with only clustered index (CL_IX), no othe…

  vgv8

  1 replies

  14 years, 10 months ago

  By: Grant Fritchey

• Scheduling System Database

  hello.. i'm looking for advice in constructing my database (using wamp server) in Room Scheduling S…

  silfolion009

  8 replies

  14 years, 10 months ago

  By: silfolion009

• Hashing data in existing schema

  Greetings good folks! I have an unusual request. I have a table in a database for customers which h…

  anish_ns

  11 replies

  14 years, 10 months ago

  By: anish_ns

• Loading two header / detail XML files out of sequence

  SQL Server 2008. Morning, If someone could offer their advice it would be very much appreciated. …

  FairFunk

  3 replies

  14 years, 10 months ago

  By: FairFunk

• Items with category and subcategory

  Hi, I have an entity named Item that has following attributes: Item: Name, Category, Subcategor…

  ioani

  4 replies

  14 years, 10 months ago

  By: ioani

• Cascading Deletes on a login table: FK integrity or audit accuracy?

  I have a non-technical design question - something more along the lines of "what's everybody out th…

  Simon E Doubt

  6 replies

  14 years, 11 months ago

  By: Simon E Doubt

• pre and post question

  Hi all, I have this table: create table #t1 (item int not null, pre int null, post int null) inser…

  Ralf Bohne

  8 replies

  14 years, 11 months ago

  By: Ralf Bohne

• Circular Reference table design

  I have read a couple of article in relation to circular reference in db and it seems there really i…

  BlackCat

  4 replies

  14 years, 11 months ago

  By: Carl Federl

• Data Warehouse as a Service

  I was reading an article presented by Kognitio recently. Now considering an enterprise approach is …

  Raunak Jhawar

  1 replies

  14 years, 11 months ago

  By: PaulB-TheOneAndOnly

• one or two entity?

  Hi to every body Suppose I have two entity X and Y that have the same definition What is the best …

  bassam86

  5 replies

  14 years, 11 months ago

  By: Grant Fritchey

• Columns order in the index

  The order of the columns in an index matters but how do I choose the right one ?

  tanuta

  1 replies

  14 years, 11 months ago

  By: Gail Shaw

• Clustering and SQL recovery mode

  I've gotten myself into an odd situation. A few months after an upgrade from SQL 2000 to 2005 (whic…

  LadyRuna

  4 replies

  14 years, 11 months ago

  By: LadyRuna

• Questions regarding database schema design that may get really funky

  Hey Guys -- Hopefully this doesn't fall on deaf ears (or blind eyes rather) 🙂 We've just started h…

  samalex

  9 replies

  14 years, 11 months ago

  By: samalex