Re: Using the result of a function as a column name.

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Why not? Fixed length names are easier to put on a report or screen,
to write check() constraints for, etc.

What report? What screen?

format ('2009-Q1' instead of '2009-Fiscal_1') but it is an entity
would have to maintain its identity (in the sense of logical
identity).

Not sure what you meant by the above.

I just want to as, have you ever worked on OLTP with high concurent number
of transactions? Are you aware that having wide CI may hurt performance ,
not talking about disk space and maintenance....




"--CELKO--" <jcelko212@xxxxxxxxxxxxx> wrote in message
news:9316629f-a345-4bcb-aca2-581c8cbe9f64@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
But why using CHAR(15) instead of VARCHAR(15)? <<

Why not? Fixed length names are easier to put on a report or screen,
to write check() constraints for, etc. But the point is that this was
a skeleton and that was just a number; in a real schema, the length
would be determined by some internal group (probably accounting or
marketing) and so would the CHECK() constraint.

What if I want to change the name of report later on do you think you
did not produce a fragmentation? What if during a transaction JOIN ON
period_name you change the name of report? <<

You are being absurd. First of all, what new names would you give the
first fiscal quarter of 2009? I might change my name to a different
format ('2009-Q1' instead of '2009-Fiscal_1') but it is an entity
would have to maintain its identity (in the sense of logical
identity). Next, reporting periods are usually fixed by law; or if
they are historical, th4ey are fixed by reality (i.e. I cannot change
Ramadan 2000 to anything else). But let's keep being silly -- What if
I want to change the value of pi in a look up table?




.

Relevant Pages

  • Re: Using the result of a function as a column name.
    ... Fixed length names are easier to put on a report or screen, ... to write checkconstraints for, ... You are being absurd. ... format but it is an entity ...
    (microsoft.public.sqlserver.programming)
  • Re: asp.net report DbSource
    ... DataSet with DataRelations that provide foreign-key constraints? ... being used in the report. ... the base query is used by SQL'05 reporting ... DataColumn is causing the trouble and fix the schema. ...
    (microsoft.public.dotnet.general)
  • Re: ISE 10.1 - Initial experience
    ... improvements, mainly concerning GUI (like report, for cross probing to ... at first I was quite frustrated: many timing constraints not ... I'm just worry about LUT and FF increase after map: ...
    (comp.arch.fpga)
  • Re: Xilinx Timing constraint problems
    ... in the UCF file. ... One of the constraints ignored comes from Xilinx's ... constraint seems ignored and looking in the timing report it is these ... report and check the path coverage. ...
    (comp.arch.fpga)