alter database myowndb set offline with ROLLBACK IMMEDIATE  will do the job

- your execution plan will clarify this

- as always " it depends "

  * wich type of join are you using (inner /left-right...

rule n° 1 on every rdbms : tell your engine what you know

my 2ct

I suppose you've already checked :

- http://www.sqlservercentral.com/columnists/jsack/aweadventures.asp

- http://www.sql-server-performance.com/awe_memory.asp

- http://www.devarticles.com/c/a/SQL-Server/How-to-Perform-a-SQL-Server-Performance-Audit/4/

- use perfmon to check on your I/O activity

- SQL92-standard adaption.

- access-engine is not sqlserver-engine

- maybe it's on the wishlist for sql2k5

select col1 + col1 as expr1, (col1 + col1 )* 2 as twice_expr1

from a_table

did you look at BOL for CHECKSUM ?

imo a modulus is jus a math-exercise, so leading zeroes do not matter, but for correctness allways have them leading your string and handle the CD in your input-presentation layer...

maybe this is a start ...

select t1.date1, identifier1, data1

from table1 t1

where t1.date1 between (select min(date2)

                                     from table2 t2min

                                        where t2min.identifier2 = t1.identifier1

                                           and t2min.date2 > t1.date1)

                      and (select...

- 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...