I have not heard of hyperthetical indexes, however you may have system stats - search sysindexes

select o.name,i.name from sysindexes i join sysobjects o  on...

Yup the trick is to update the originating server column to your correct (new) server and the jobs will then work ok.

You must also make sure your database collations...

It would be better to discover why you have the problem and deal with it - this path is only a fix not a solution.

I'm not aware of being able to do what you require, it would probably be very intenisive monitoring anyway. I'm not too sure what you actually want to achieve.

You can but it's probably not supported and I suggest if you're asking the question then maybe you shouldn't < grin >

The only real reson I can think you'd want...

sorry can't leap across to the link .. if you use dbcc chrinkfile(1)  for example this attempts to shrink the datafile back to its original creation size. I've found this...

Unless I'm mistaken changing a column data type requires a table rebuild and the various T SQL or gui commands only do this behind the scenes.

I happen to know the solution to this ( experience!! ) to get the space back you must use a dbcc shrinkfile(1)  which attempts to return the mdf file back...

We did manage this but it is fraught with problems, the issue is getting each node to see the same name -- the issue is with the quorum registry info...

I run 32gb ram using awe with no problems. I saw cpu drop significantly. 

As mentioned if you have sp4 applied you must have a fix applied

SQL2000-KB899761-v8.00.2040-x86x64-ENU.exe

which fixes a...

I'm sorry I can't actually post the actual code - the query is the correct query ( with names changed ) where the two variables are the parameters passed to the...

sure you don't have some nvarchar columns ? each one is 2 chars so a nvarchar(100) is actually 200 wide.

It's this whole issue of spindles and controllers which seems to blur with the files. I have used/understand the use of seperate controllers/channels per raid - I've set raid 10...

a large select  ( * ) will always be problematic .. you need to clear your data cache before each run if you want a consistant timing. Data may or...

This has been mentioned a number of times at Technet presentations and is said to apply to raid arrays too.

I am unsure too as one part of me says...