- A rebuildindex will lock the object involved, so might interfere with your apps

- indexdefrag will not optimize as good as rebuildindex

afaik (my guideline)

if the keyvalue(-combination) of your clustered ix is unique, it is designed to be the same.

if not, sqlserver will add a uniquifier to the clustering-index-key(s).

But in this case,...

- you might use constraints to limit the numbers so only positive values are allowed.

- you could use a trigger so negative values are converted to positive values.

- but why...

don't know if it helps... 

 strConn = strConn & " INTEGRATED SECURITY='sspi';"

quotes added

- use decimal[(p[, s])]  check BOL in stead of float.

- check constaints can help to delimit values :

   from BOL :

     ALTER TABLE doc_exd 

         ADD CONSTRAINT exd_check CHECK (column_a between...

no.

are the nt-users domain-users ? logged on to the right domain ? member of the correct nt-group ? within the correct dns ?

check...

- did you run sp_statistics on all the db after the upgrade ?

- execute your maintenanceplan or rebuild your indexes

- I'd only use a udf if there 's a need to be able to use it as a column _in_ a select clause . all others should go for...

- I'd say this is not what I'd call a UDF. Transform it into a normal select.

- remember a UDF works at row-level

- "select isnull(sum(line.totalQty),0) 

April 19, 2004 at 5:01 am