You will have to alter the object-owner !

this may help out :

Select  'print '' object : ' + u.name + '.' + o.name  + ''' '  + char(13) + ' go...

- keep in mind that sql also has to manage rowlayout, nullable columns also have the need for management-place (1 byte per 7 nullable columns). Check "dbcc showcontig" for your...

Every time sqlserver starts (or starts a db) it will check if data is consistent.

If it detects there were running transactions at...

sysdepends may give you the inventory.

sp_refreshview @viewname =  'viewname'  may perform what you are looking for

- Because your goal is to move the db to a new server and postpone application-adaption, maybe you can consider to move the db's and at the old location only...

When reindexing put your recovery model to bulk-logged or your log will grow by the size of the rebuild data..

But don't let this discourage...

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