I change the index to unique and update statistics with full scan.
on table a14 the statistics is wrong.
look at this picture

Actual number of row is 0 but estimated...

thank you,
This index already exist on this table. but I think has a problem with statistics of this index.
at network_v3 table, field objectID has a 1493760 distinct values...

Thank you.
But in Network_V3 fields (SDE_State_ID,Geometry_ID) does not exist and this field is in the SDE_Geometry4 table.
I Create this index
create index IXTEST4 on sde_geometry9 (Geometry_ID,sde_State_id)

Hi,
I create a monitoring database and create SP for each scripts that I need for monitoring servers.
For updating monitoring DB also create a database project in VS 2015 ...

Hi,
No you cannot use collate in select from view. you can change collation in body of your view .

user before archiving can change this number,but after archive the vouchers,cannot change this number.

No.This is a real number.

Because this number is referenced.When Accountant archive voucher this number is reference in the archive.

Because in my country the finance organs need to sequence the voucher number.

for now, i create a temp table and insert all the vouchers into temp table. then select all...

Hi.Thanks.

How to redesign my table.

I have to table for Vouchers. An header table and detail.

in header table i save this data.

------------------

Voucher_Number,Date voucher,User,Type_Voucher

In detail table i save this data.

--------------------

Voucher_Number(Fk of header...