I did run DBCC CHECKDB ('Stg_Budget') WITH NO_INFOMSGS and got the following....

Msg 8909, Level 16, State 1, Line 1

Table error: Object ID 334624235, index ID 0, partition ID 72057594051166208, alloc...

it is not RAID, as that is a test server, we are managing with local disks.

yes we do but any idea why is this occuring all of a sudden only on that server, can i blame the disk drive for it or any thing that...

I am just asking in general,i dont have any query. the reason is some of the developers come to me saying that they ran a query 2 days back and...

I was thinking of having additional identical server may be a stand by server but how can I swith server names with in no time by which even users should...

Yeah i was thinking about those options but was wondering how they work without moving any drive manually from one server to another, could you please breif me benefits and...

the log file is as much as usual database size, i think though it is in simple mode if the transactions are not cimitted it will grow big.

what would happen...

I killed the transaction as the dsik was compeltely full and it may take same time to roll back, i am not sure if there a best way to...

it is in simple mode and i am using a stored procuedure where it has diffrent business criteria to read data from a production server and then insert into this...

I am trying to shrink the db but could not do it as the INSERT's are blocking, how would i proceed ?

I would really like to know how we can do this without giving BulkAdmin previlages but i would also eager to knoe if there are any disadvantages giving BulkAdmin access...

how do i do this on all tables, all databases in a server.

would there be any case where temdb is filled with temp transactions and space did not get released back after the completion of the job.

thanks

Auto Updates Statistics is true ON and indexes are properly built all the databases including the problem database and i dont blame the qry as the same qry runs faster...

is there a way to increase performance withour using temp tables ?