Again, I'm answering this with little to no information, so please take anything here as mild suggestions, not major pronouncements...

What about a design something like this:

Table: Item

Columns: ItemId

Size

Color

Description

Cost

?

Table: Order

Columns: OrderId

Company

OrderDate

DownPayment

?

Table:...

It depends on the UDF, but frequently they have no statistics on them, so the optimizer assumes one row. Since, in this case, it really will be one row, I...

One other thought, this sort of thing usually derives from something the business thinks it's not getting, so it wants to put a more business focused person in place. You...

Oh, then yes, the data describing the databases is stored in a series of views called dynamic management views. So that's yes to all three.

If I understand the question, why don't you just maintain this data in a table? Even if it's only one or two rows, you can join against it when you...

1 & 2, definately.

I'm not sure I understand what #3 is.

Be very, very nice about it, but get it down in writing that you're suggesting this might be a poor decision. Then, as long as you're getting paid... train away....

What does the procedure GETSTOCKLEDGER do? It sounds like you may have incorrect syntax in there, but it could be something wrong on the server itself.

No. That's a bad plan. If you're maintaining a 2000 database, you should be testing against a 2000 database. There were changes, not necessarily big ones, but they're there, to...

I had to clean up your code just a bit, but it works just fine:

--created the tables so I could play

IF NOT EXISTS ( SELECT *

...

Oops. Modulo 3.

:blush:

twity61 (4/30/2008)

---

what do I examine the clustered index?

yes. the users selecting the data that is being updated.

the update take about 15min.

snapshot isolation is good idea. I think it's...

I wasn't thinking about it earlier, but you could just write the whole thing in SSIS. That will multi-thread very well.

Have you run a trace to capture the calls coming in to the server? Even if you identify a CPU problem, you need to figure out what's causing the problem.

a2zwd (4/30/2008)

---

Hi,

I am developing an application to a garment factory. I have a doubt in designing a table.

Basic tables:

Jobs, JobColors, Material, Units, Currencies ...

These tables are designed with normalization rules.

I...